Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tallying more than one list of data into one main control list
I have to tally a year's worth of monthly data of attendees by one county's
zip codes into one main list of zip codes. (ie. San Francisco County has 20 zip codes, in January only 8 zipcodes were represented, February 10 were represented, etc.) How do I tally each month's zip codes and attendee count into the main excel sheet w/ all of SF's zipcodes if the not all zip codes fields are used each month? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tallying more than one list of data into one main control list
Are you asking for advice on how to lay the data out, or how to
achieve the tally? I would suggest if you have a list of all the zip codes in column A starting with A2, then you can put 1, 2, 3 etc in B1, C1, D1 etc to represent months. Then you can use a SUMPRODUCT formula to give you the totals against each zip code for each month. As you do not give any details of how your data is laid out, I can't give you a suggested formula, so post back with more details if you need further advice. Hope this helps. Pete On Sep 18, 5:48*pm, jayh wrote: I have to tally a year's worth of monthly data of attendees by one county's zip codes into one main list of zip codes. *(ie. San Francisco County has 20 zip codes, in January only 8 zipcodes were represented, February 10 were represented, etc.) How do I tally each month's zip codes and attendee count into the main excel sheet w/ all of SF's zipcodes if the not all zip codes fields are used each month? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
List control | Excel Discussion (Misc queries) | |||
How do i delete data from a main xl list using another xl list??? | Excel Discussion (Misc queries) | |||
how to compare a list of data that is same as the main data sheet | New Users to Excel | |||
Selection from list on main sheet from suplemental sheet in same w | New Users to Excel |