can I sum information in a list
 

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).

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

Jim Thomlinson


"WTG" wrote:


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).