I like that Bob!

Even works without the "Product":

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
=SUMPRODUCT(SUMIF(INDIRECT({"C3","C14","C25","C34" ,"C41"}),"0"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Lady_Olara" wrote in message
...
range:
C3,C14,C25,C34,C41

criteria:
0

sum-range:
C3,C14,C25,C34,C41

I can't get that to work since the commas in the range are throwing the
function off.