How to sum lots of columns(over 200) with one criteria?

S

smart.daisy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif from two criteria in one column 4
sum product if 2
How to copy the function SUM but offseted in 7 columns 2
DSum - criteria in different row than value to sum 2
How to distribute/spread/map cost of project across different year 3
Sum up 2 or more columns under same SUMIF criteria 2
sum until criteria not met 5
How to create a 3D surface graph from 3 columns of data: one columnfor x, one for y, and one for z 3

Top