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