Thread: SUMIFS
View Single Post
  #6  
Old June 4th, 2010, 05:47 PM posted to microsoft.public.excel.misc
Rak
external usenet poster
 
Posts: 12
Default 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 ( )