Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to sum lots of columns(over 200) with one criteria?
I have a table as following format:
Month 1 Month2 Month3 Month4 sub Total Name hours Name Hours Name Hours Name Hours...... Dog Cat Bee Dog 50 cat 50 dog 40 Dog 30 ....... ? ? ? Cat 30 Bee 20 Dog 10 Bee 5 ........ ? ? ? Name is a drop-down list(text). I need to make a subtotal for each name. Since I have over 200 columns, I can't use SUMIF to manually add all columns. Maybe SUMPRODUCT can work but I can't figure out the formula. Any suggestion is welcome! Thanks. |
#2
|
|||
|
|||
Try this, Daisy:
http://www.officearticles.com/excel/...ft_excel.h tm ************ Anne Troy www.OfficeArticles.com "smart.daisy" wrote in message ... I have a table as following format: Month 1 Month2 Month3 Month4 sub Total Name hours Name Hours Name Hours Name Hours...... Dog Cat Bee Dog 50 cat 50 dog 40 Dog 30 ....... ? ? ? Cat 30 Bee 20 Dog 10 Bee 5 ........ ? ? ? Name is a drop-down list(text). I need to make a subtotal for each name. Since I have over 200 columns, I can't use SUMIF to manually add all columns. Maybe SUMPRODUCT can work but I can't figure out the formula. Any suggestion is welcome! Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to merge lots of info, w/o copy paste? | Excel Worksheet Functions | |||
lots of data | Excel Discussion (Misc queries) | |||
Cells containing lots of text will not wrap? | Excel Discussion (Misc queries) | |||
hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA. | Excel Discussion (Misc queries) | |||
Sorting lots of data | Excel Discussion (Misc queries) |