Posted to microsoft.public.excel.worksheet.functions
|
|
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
|