Need help with an Excel formula [Resolved]

Given the following data, I'd like the sum of data in column B where column A is "good".

A_________B
good______10
good______20
good______10
bad_______99
bad_______99
good______10

So in this case I'd like 50 to appear under column B.

Seems like you need a hidden column C

With a formula like =IF(A1="GOOD",B1,0)

Dup that - sum it at the bottom and put the total in column B...

Don't have EXCEL on this workstation - so I could have bad syntax...

Thanks. I got help from someone else and this works without a hidden column.

=SUMIF(A:A,"good",B:B)

EXCEL - what a mystery;)

I have a colleague I always call on for stuff like this - I didn't even know there was a SUMIF function - but it sure makes sense in this respect...