can I sum information in a list

W

WTG

I have a speadsheet (TICKETS) the has the following list from cells
A1:K1000.



ticket ticket ticket customer product amount
date time number id id



On another sheet (INVOICE) if I enter in cell a1 a starting date, and
in cell b1 a finishing date.

Can I make a drop down list that will show me a summary ofall
customers in my list of tickets, between the starting and finishing
dates?
(there may be 1000 tickets, but only 100 different customers. and the
ticket list may be for the year but I only want a certian month).
 
J

Jim Thomlinson

You can use Autofilters -> Custom to create the lists. As for a drop down
that is distinctly more difficult.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top