Try


=SUM(SUMIF(INDIRECT({"A2:A14","A17:A25"}),"0",IND IRECT({"R2:R14","R17:R25"})))

--


Regards,


Peo Sjoblom

"Compass Rose" wrote in message
...
Is it possible to have non-contiguous (I think that's the right word)
ranges
in a SUMIF statement? If so, is this the correct syntax to define the
range?
For example:

=SUMIF(A2:A14,A17:A25,"0",R2:R14,R17:R25)

TIA

David