That formula works for me, is your column AN formated as text
Regards
Steve
"RAK" wrote in message
...
My SUMIFS formula was "accepted" but the result is 0.0 even though there
are
numbers to add. What can the problem be?
The formula is =SUMIFS(AN3:AN997,C3:C997,"ARC",D3997,"EOC")
I want the total form column AN when column C is ARC and when column D is
EOC