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
Bookmarks