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

Originally Posted by argomike

Pete,

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

You know, I've never come across that particular error message before. It worked for me in the test file, so I can only assume that you have introduced some typing error. Obviously, you should not place that formula within any of the ranges that it covers (i.e. put it in column D somewhere) and you should check that you have typed it out correctly as there are a lot of brackets in there. To avoid typing mistakes, copy the formula from the above post and paste it into the formula bar with a cell in column D selected. Then make the adjustments to the ranges to suit your data.

Hope this helps.

Pete

Originally Posted by argomike

Pete,

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

You know, I've never come across that particular error message before. It worked for me in the test file, so I can only assume that you have introduced some typing error. Obviously, you should not place that formula within any of the ranges that it covers (i.e. put it in column D somewhere) and you should check that you have typed it out correctly as there are a lot of brackets in there. To avoid typing mistakes, copy the formula from the above post and paste it into the formula bar with a cell in column D selected. Then make the adjustments to the ranges to suit your data.

Hope this helps.

Pete