Need help with SUM IF formula
 

I have set up the following formula: =SUM(IF(D2:D21="IR",IF(C2:C21=53,1,0)))
it need to count when ever at D2:D21 there is an IR and at C2:C21 there is
value of 53.
When checking the formula I get the currect results but at the excel sheet I
get different number - how come?

Pls contact ronen.toren for picture to better explainthe issue

do a count if, that sounds like it would work better for you...


--
ehntd
------------------------------------------------------------------------
ehntd's Profile: http://www.excelforum.com/member.php...o&userid=15865
View this thread: http://www.excelforum.com/showthread...hreadid=277680

Hi
you have to enter this kind of formula as array formula with
CTRL+SHIFT+ENTER. After this the formula shoulb be shown enclosed with curly
brackets in the formula bar.

an alternative formula would be
=SUMPRODUCT(--(D2:D21="IR"),--(C2:C21=53))

See for this:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

"Ronen Toren" wrote:

I have set up the following formula: =SUM(IF(D2:D21="IR",IF(C2:C21=53,1,0)))
it need to count when ever at D2:D21 there is an IR and at C2:C21 there is
value of 53.
When checking the formula I get the currect results but at the excel sheet I
get different number - how come?

Pls contact ronen.toren for picture to better explainthe issue