You're welcome. Thanks for the feedback!

Biff

"Carol" wrote in message
...
It WORKED! Beautiful! I've never seen the "ROWS" thing before.... but
love
it!
Thank you so very much!
--
Carol


"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A$1:A$10=""),--(B$1:B$10=ROWS($1:1)))

Copy down a total of 3 cells.

The first cell will be the count of 1's. The second cell will be the
count
of 2's and the third cell will be the count of 3's.

Biff

"Carol" wrote in message
...
Column A holds "X" or "" (blank). Column B holds "1", "2", or "3".
I need to count the number of 1s, 2s, and 3s, in column B when the cell
in
column A is blank.

I've tried several variations of IF, AND, & COUNTIF - can't get
anything
to
work. Have also tried many variations of SUMPRODUCT found in other
posts.
None are working for me.

Can you please help? Is there a way to do this?
Thank you!
--
Carol