June 4th, 2010, 05:47 PM
posted to microsoft.public.excel.misc
|
|
SUMIFS
"RAK" wrote:
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
AN is formatted as numbers (format cellNumberNumberpositive 1234.0 w/o ( )
|