Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting x instances of a string across columns...
A B C D Yes No Yes Yes No No No Yes No Yes Yes No Yes Yes No No What I'm trying to do is count the cases where there is one "Yes" (or maybe 2 or 3 yeses) in any of the columns, with one formula for the entire array. So to count rows with one yes, there would be 1. With 3 yeses, there would be 1 row. With 2 yeses, there would be 2 rows. Can't figure out how to do this without using a helper column, any help is appreciated.. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting the number of instances of a string within another string | Excel Worksheet Functions | |||
Counting instances that 2 different columns match | Excel Worksheet Functions | |||
Countif function for instances of text string contained | Excel Worksheet Functions | |||
Countif function for instances of text string contained | Excel Worksheet Functions | |||
Counting instances in a cell | Excel Discussion (Misc queries) |