Sum colunms base on same header

[xtwo]

Hello all,

I am new here, and also new to excel. I have the data as below, and I tried to sum up the columns which have the same header together and others separately. I played with sumif function for while and googled it but no help, I am not sure why the below formula could not sum up the highlight ones.

=SUM(IF(C1=D1,C2:D10517,0))

I'm really appreciated with any of your inputs.

Regards,

 

[*shudder*]

If I am understanding your correctly you will need something more like this:

=IF(C1=D1,SUM(C2:D10517),0)

 

[doublej_jj]

I'll give you a formula that should work, and try to explain why it works:

In cell C10518 =sumproduct(($C$1:$Z$1=C1)*($D$1:$Z$10517))
copy that to the rest of your columns.

First I assumed your columns went out to Z, you can change this appropriately.

The $C$1:$Z$1=C1 looks at your header and sees which ones match the header of the row you are in. If it is true, Excel says the answer is 1. If it is false, Excel says the answer is 0. It then multiplies all the 1s and 0s from your header piece times each piece of data below it and add the products all up.

If you are real beginner, the $'s make it so that range does not change when you copy it to adjacent cells.

The explaination may be a little weak, but I hope this puts you in the right path.

Jeff