Count

  • Thread starter Thread starter CraigMacE
  • Start date Start date
C

CraigMacE

I have two columns, the first has a list of numerical values and the second
has yes or no values. I want a formula to count the number of times a "yes"
appears without a number in the other column.
 
One way....
(assuming your data is in columns A and B and in rows 1 to 10 - adjust to
suit, but you must maintain an equal number of rows in the formula!)
=SUMPRODUCT(--(A1:A10=""),--(B1:B10="yes"))

Or......
=COUNTIFS(A1:A10,"",B1:B10,"Yes")

Rob
 
Try this...

A1:A10 = numeric values or empty
B1:B10 = yes or no

=SUMPRODUCT(--(A1:A10=""),--(B1:B10="yes"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the columns from one sheet and paste it in another sheet 0
counting blank cells within two columns 2
SumProduct counting negative numbers 2
Problem not counting duplicates 1
counting formula 8
Count if with multiple criteria 3
COUNT BETWEEN A RANGE AND 16
Using text values in Pivot Tables 5

Back
Top