| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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). |
|
#2
|
|||
|
|||
|
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). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I sum information in a list | Excel Worksheet Functions | |||
| List ? - How do I make information in one cell determine list to u | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
| make list of information from different cells | Excel Worksheet Functions | |||
Linear Mode
