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