Multi-Column Counting - COUNTA or other Options

Pete,

This one doesn't seem to be working. I get the following error: "Range has no entry corresponding to the cell"

Originally Posted by Pete_UK

Hi Argomike,

You can do it in a single formula if you count the number of rows in your range and subtract from that the rows that contain 3 blank cells, something like:

=ROWS(A2:A9)-SUMPRODUCT((A2:A9="")*(B2:B9="")*(C2:C9=""))

Obviously the 9 in my formula will be 10000 or whatever in your real file.

Hope this helps.

Pete