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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count#cells w/= value in other column and not count blank c
=SUMPRODUCT(--(A1:A9=B1:B9);--(NOT(ISBLANK(A1:A9))))
-- Regards! Stefi €˛aganoe€¯ ezt Ć*rta: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count#cells w/= value in other column and not count blank c
Try the below
=SUMPRODUCT(--(A1:A9=B1:B9)*(A1:A9<"")) -- Jacob (MVP - Excel) "aganoe" wrote: 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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count#cells w/= value in other column and not count bla
Thanks, all three suggestions work!
"Stefi" wrote: =SUMPRODUCT(--(A1:A9=B1:B9);--(NOT(ISBLANK(A1:A9)))) -- Regards! Stefi €˛aganoe€¯ ezt Ć*rta: 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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count#cells w/= value in other column and not count bla
You are welcome! Thanks for the feedback!
Clicking the YES button will be appreciated. -- Regards! Stefi €˛aganoe€¯ ezt Ć*rta: Thanks, all three suggestions work! "Stefi" wrote: =SUMPRODUCT(--(A1:A9=B1:B9);--(NOT(ISBLANK(A1:A9)))) -- Regards! Stefi €˛aganoe€¯ ezt Ć*rta: 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! |
Reply |
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 |