COUNTIF() doesn't work on disjoint ranges. The usual approach is to use
several COUNTIF()'s and add them up.
--
Gary's Student


"broush" wrote:

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.