ExcelBanter - Count

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Count (https://www.excelbanter.com/excel-discussion-misc-queries/194454-count.html)

CraigMacE

Count

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.

RobN[_2_]

Count

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

"CraigMacE" wrote in message
...
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.

T. Valko

Count

Try this...

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

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

--
Biff
Microsoft Excel MVP

"CraigMacE" wrote in message
...
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.

All times are GMT +1. The time now is 06:18 PM.