Conditional Addition

Hey all,

I'm having some difficulties formulating an IF statement. Here's what I'd like to do


If any cell in Column B = 1, then add the Column H# of that row. I hope that makes sense.

=IF(B:B=1,+H:H,0)

It worked for the first cell (B4 and H4), but when I tried to add the #1 to B5 and put a value into H5, it won't sum it up.

I'm sure this question is elementary, but I'm very new to using functions in excel. Any help would be greatly appreciated!

Try

=Sumif(B:B,1,H:H)

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save