Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |