Hi,

You may want to try the following array formula (Ctrl+Shift+Enter):

=count(if(((range=1)+(range=2)+(range=3)*(range2=" ")),range2))

Regards,

Ashish Mathur

"Steve" wrote:

I'm counting blank cells with this formula:
=COUNTIF(Y3:Y223,"")

In column X, I have this formula =LEFT(S74,1), which results in either a
1, 2 or 3

How could I count the blank cells that correspond with the 1's, the 2's &
the 3's ?

Thanks,

Steve