Thread: SUMIFS
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rak Rak is offline
external usenet poster
 
Posts: 6
Default SUMIFS

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",D3:D997,"EOC")
I want the total form column AN when column C is ARC and when column D is EOC