View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Count data in one column indicated by data in another column

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