| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count#cells w/= value in other column and not count blank c
In column A, I have values equal to either YES, NO or NA. In column B, I
have values equal to either YES, NO or NA. I want to count the # of cells in column B that equal to their counterpart in column A, but I do not want to count blank cells, ex: A B 1 Yes Yes 2 No No 3 NA No 4 5 Yes Yes 6 Yes Yes 7 8 No No 9 No No Result for B10 should be 6 as I do not want to count row 4 and row 7 thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Non-Blank Cells in Column If a Reference Criteria Met. | Excel Discussion (Misc queries) | |||
| Only count columns if the column next to it is not blank | Excel Discussion (Misc queries) | |||
| Count Non Blank in column | Excel Discussion (Misc queries) | |||
| COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN | Excel Worksheet Functions | |||
| count non blank cells which meet criteria in another column | Excel Worksheet Functions | |||
Threaded Mode
