HELP! SUM for data in same row, but different columns with the same header

I've been trying to use variations on a "SUMIF" formula to do this calculation, but with no luck; my results keep come back "0" when that shouldn't be the case. An example of what this data looks like is as follows:

Population Margin of Error Population Margin of Error Population Margin of Error
A 100 200 300 400 500 600
B 600 500 400 300 200 100
C 300 400 100 200 600 800
D 200 700 500 200 900 100

Essentially I want to calculate the contents of Row A only for those cells in Row A whose column header is "Population."

Your help is greatly appreciated. Thanks.

Best,
AB

Hi AB,

Try this in G2 then copy this cell to the rest...

=SUMIF($A$1:$F$1,$A$1,A2:F2)

Hi AB, sorry for being presumptuous, but is "Population" spelled correctly? Both in Row 1 and within the formula... that includes extra spaces and all...

Originally Posted by djapigo

Hi AB, sorry for being presumptuous, but is "Population" spelled correctly? Both in Row 1 and within the formula... that includes extra spaces and all...

As you can see, "Population" is not actually in the sheet; I just thought it would be a clearer Header term for an example. I'm trying to add cells across a row in all "Estimate" columns.

So, what's the formula that you are using? Also, instead of a *.jpg, can you attach and excel spreadsheet (make sure to "dumb it down" so that we don't see any sensitive information)...

Wait, I think I figured out why you are getting 0's... it's because your Estimate numbers are actually text (hence the green triangles)... can you use this formula instead...

=VALUE(B3)+VALUE(D3)+VALUE(F3)+etc.

Originally Posted by djapigo

So, what's the formula that you are using? Also, instead of a *.jpg, can you attach and excel spreadsheet (make sure to "dumb it down" so that we don't see any sensitive information)...

Wait, I think I figured out why you are getting 0's... it's because your Estimate numbers are actually text (hence the green triangles)... can you use this formula instead...

=VALUE(B3)+VALUE(D3)+VALUE(F3)+etc.

I think you're right about the Cell values downloading as text. Is there some way to correct this without going into each cell individually? I found that when I did that for a few cells and reduced the range of the formula I finally got results.

The method you propose, adding all cells manually seems fairly time consuming, no?

Sheet.jpg

This is an excerpt from the file I'm dealing with. The formula would have to calculate a SUM for 50 cells in each row separated by 50 more cells alternating in between. Essentially I want to quickly add every other cell in the row.

So, what's the formula that you are using? Also, instead of a *.jpg, can you attach and excel spreadsheet (make sure to "dumb it down" so that we don't see any sensitive information)...

Originally Posted by BB1972

I presume you don't want a picture of the answer, so have a look at the attached workbook, which shows both SUMIF & SUMIFS formula doing what I think you want to do.

Thanks. I don't know how to upload a workbook on here yet (I just joined). The formula examples you gave are exactly the ones I've been trying to use.

Hi AB... uploading workbooks is no different on how you attached the picture...