If/then help

[wbco]

Looking for help on this one..... Basically, if cell A1, C1, or E1 has a 1 in it, then in cell G1, give me a total of what's in B1, D1, F1

 

[Joe4]

Place this formula in G1:
=IF(OR(A1=1,C1=1,E1=1),B1+D1+F1,"")

 

[wbco]

Awesome! Thank you for the quick reply!... it almost works.... but its adding B1, D1, and F1 even if there's not a value of 1 in A1, C,1, or E1...

I need it so if A1, C1, or E1 has any number other than 1 in it (or blank) then don't include it in the math of B1, D1, and F1

Place this formula in G1:
=IF(OR(A1=1,C1=1,E1=1),B1+D1+F1,"")

 

[Joe4]

OK, that was not clear from your first post.
So it sounds there is a correlation between A1 and B1, C1 and D1, and E1 and F1.

Try this:
=IF(A1=1,B1,0) + IF(C1=1,D1,0) + IF(E1=1,F1,0)

 

[wbco]

Perfect!!!! Thank you!!!!!!!

OK, that was not clear from your first post.
So it sounds there is a correlation between A1 and B1, C1 and D1, and E1 and F1.

Try this:
=IF(A1=1,B1,0) + IF(C1=1,D1,0) + IF(E1=1,F1,0)

 

[Joe4]

You are welcome.

 

[wbco]

Sorry... one more question... how would I make it so if there is no data in the cells, then the formula cell will just be "blank", rather than displaying a "0" ?

OK, that was not clear from your first post.
So it sounds there is a correlation between A1 and B1, C1 and D1, and E1 and F1.

Try this:
=IF(A1=1,B1,0) + IF(C1=1,D1,0) + IF(E1=1,F1,0)

 

[Joe4]

One way:
=IF(A1&C1&E1="","",IF(A1=1,B1,0) + IF(C1=1,D1,0) + IF(E1=1,F1,0))

 

[wbco]

Perfect! Thank you, again!