=SUMPRODUCT(COUNTIF(INDIRECT({"A2","B7","H9","I1"} ),"0"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"broush" wrote in message
...
I am trying to use the countif function to add non-contigous cells but I
am
getting an error. I want to count 4 cells on a sheet that have a value
greater than 0.