CountIf functions
 

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


--
themax16
------------------------------------------------------------------------
themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622
View this thread: http://www.excelforum.com/showthread...hreadid=437982

themax16 Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=437982