View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek
 
Posts: n/a
Default SUMIF non-contiguous range



Ragdyer wrote:
I like that Bob!

Even works without the "Product":

=SUM(SUMIF(INDIRECT({"C3","C14","C25","C34","C41"} ),"0"))


See also a previous occasion on the matter:

http://www.mrexcel.com/board2/viewtopic.php?t=29977