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.

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.