Thread: sumifs will not work with a cell reference as criteria
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BillGr BillGr is offline
external usenet poster
  
Posts: 2
Default sumifs will not work with a cell reference as criteria
Where cells M12 and M15 contain the number 39315 and 39317, respectively.
The formula yields no results when M12 and M15 are in the formula. However,
when I substitute the actual number in the formula, the proper result is
produced.

=SUMIFS(G2:K2,$G$1:$K$1,"=M12",$G$1:$K$1,"<=M15") does not work
=SUMIFS(G2:K2,$G$1:$K$1,"=39315",$G$1:$K$1,"<=393 17") works
Reply With QuoteReply With Quote