| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting cells in two columns that have the same results
I'm trying to come up with a formula that would give me a count of a yes/no
combination in two different columns like below: K L 1 Member Approved 2 y y 3 y n 4 n y 5 y y where I can get a count of the "Y" in column K that are also "Y" in column L, in other words, the members who are also approved. I've tried stringing two countif formulae together, but can't seem to get that to work. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Counting blank cells until value is reached | Excel Worksheet Functions | |||
| Formula for counting number of cells | Excel Discussion (Misc queries) | |||
| abdualmohsn | Excel Discussion (Misc queries) | |||
| PLEASE HELP - Pasting Cells to WrkSheet with Hidden Columns | Excel Worksheet Functions | |||
Threaded Mode
