Try this:

=SUM(COUNTIF(YourRange,{"0",6}))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Paul" wrote:

I probably wasn't clear, I want to return a count of the number of cells
that meet that criteria.

"Paul" wrote in message
...
I am trying to test and count non-contiguous cells in form our HR
department made. There are to be numerical values entered in these cells,
but not every cell. I figured I could use CountIf, but I'm a little rusty
on Excel. Something like: =CountIf([Referenced Cells], AND(0, ,6)) but I
keep getting an error. Any help would be appreciated.

Thanks

Paul