CountIf functions

T

themax16

Afternoon all..
I wondered if you could maybe help me..
I am trying to create a formula that will check the content off on
colum and if this reads 'closed' then will add the value in a secon
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 i
7+2+4 = 13

How can i do this?

many thanks

Jame
 
B

BenjieLop

themax16 said:
Afternoon all..
I wondered if you could maybe help me..
I am trying to create a formula that will check the content off on
colum and if this reads 'closed' then will add the value in a secon
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 i
7+2+4 = 13

How can i do this?

many thanks

James
Click to expand...

This formula

=SUMIF(B1:B5,\"CLOSED\",A1:A5

will work for you.

Regards
 
Top