CountIf functions

Originally Posted by themax16

Afternoon all..
I wondered if you could maybe help me..
I am trying to create a formula that will check the content off one colum and if this reads 'closed' then will add the value in a second colum.

e.g
A B
7 closed
1 open
2 closed
4 closed
5 open


So if colum B = closed it will add the vaule of colum A. so total is 7+2+4 = 13

How can i do this?

many thanks

James

This formula

=sumif(B1:B5,"closed",A1:A5)

will work for you.

Regards.