Sum cell with conditions

Hi All,

I tried a nested IF statement, but came to conclusion that its a bit more complicated than i thought. I have googled Sumifs, but i don't think that will work on what i am trying to achieve, unless i am missing something.

I would like to get column AA to sum row 2 depending if the "Edits" columns are blank or not.

For example, if a user inputs a number on C2 then AA2 will ignore B2 and sum C2 with the rest of row. Now, if a user enters numbers in multiple "Edits" column such as C2, E2 and S2, then AA2 will sum C2,E2, and S2 in place of B2, D2, and R2 with the rest of the row.

My question maybe a bit confusing, so i have row 2 summed as an example of what i am trying to achieve.

Try this, here are two months, just repeat the if and isblank for remaining months. SUM(IF(ISBLANK(C2),B2,C2),IF(ISBLANK(E2),D2,E2),...)

I don't think this is a good candidate for sumif.

Originally Posted by dweingar

Try this, here are two months, just repeat the if and isblank for remaining months. SUM(IF(ISBLANK(C2),B2,C2),IF(ISBLANK(E2),D2,E2),...)

I don't think this is a good candidate for sumif.

Thank you dweingar! this wroked out great! i feel like an idiot now

Originally Posted by Bo_Ry

No one idiot, just don't know yet.

Please try
Z2
=SUMIFS(B2:Y2,B$1:Y$1,">0")

AA2
=SUMIFS(B2:X2,C2:Y2,"")+SUMIFS(B2:Y2,B$1:Y$1,"*")

Drag Z2:AA2 down

Thank you Bo_Ry !!! This works and is alot smoother than all those nested if's!! I appreciate all the help!