M Mohan BR New Member Jan 25, 2017 #1 Dear Team Kindly refer attached file in that column A contains the required results in that >=85% count against Ach % column Thanks Regards Basavaraj K H Attachments Sumproduct.xlsb 15.7 KB · Views: 8
Dear Team Kindly refer attached file in that column A contains the required results in that >=85% count against Ach % column Thanks Regards Basavaraj K H
PCosta87 Well-Known Member Jan 25, 2017 #2 Mohan BR said: Dear Team Kindly refer attached file in that column A contains the required results in that >=85% count against Ach % column Thanks Regards Basavaraj K H Click to expand... Hi, What is the expected result in column "A"? Can you post a screenshot or sample file with the required result calculated manually? Thanks
Mohan BR said: Dear Team Kindly refer attached file in that column A contains the required results in that >=85% count against Ach % column Thanks Regards Basavaraj K H Click to expand... Hi, What is the expected result in column "A"? Can you post a screenshot or sample file with the required result calculated manually? Thanks
M Mohan BR New Member Jan 25, 2017 #3 Thank You for your response, Finally I got formula like below =COUNTIFS($B$2:$EU$2,"Ach %",B3:EU3,">85%")
Thank You for your response, Finally I got formula like below =COUNTIFS($B$2:$EU$2,"Ach %",B3:EU3,">85%")
Hui Excel Ninja Staff member Jan 25, 2017 #4 The formula =COUNTIFS($B$2:$EU$2,"Ach %",B3:EU3,">85%") returns 22 But the formula =SUMPRODUCT(($B$2:$EU$2="Ach %")*($B$3:$EU$3>85%)) returns 23 If you manually check there are 23 cells that meet that criteria I haven't figured out what is wrong yet
The formula =COUNTIFS($B$2:$EU$2,"Ach %",B3:EU3,">85%") returns 22 But the formula =SUMPRODUCT(($B$2:$EU$2="Ach %")*($B$3:$EU$3>85%)) returns 23 If you manually check there are 23 cells that meet that criteria I haven't figured out what is wrong yet
PCosta87 Well-Known Member Jan 25, 2017 #5 Hui said: The formula =COUNTIFS($B$2:$EU$2,"Ach %",B3:EU3,">85%") returns 22 But the formula =SUMPRODUCT(($B$2:$EU$2="Ach %")*($B$3:$EU$3>85%)) returns 23 If you manually check there are 23 cells that meet that criteria I haven't figured out what is wrong yet Click to expand... Some cells have numbers stored as text, which is only relevant to the COUNTIF formula. Eg. "EK3" and "BS6" (the only 2 100%)
Hui said: The formula =COUNTIFS($B$2:$EU$2,"Ach %",B3:EU3,">85%") returns 22 But the formula =SUMPRODUCT(($B$2:$EU$2="Ach %")*($B$3:$EU$3>85%)) returns 23 If you manually check there are 23 cells that meet that criteria I haven't figured out what is wrong yet Click to expand... Some cells have numbers stored as text, which is only relevant to the COUNTIF formula. Eg. "EK3" and "BS6" (the only 2 100%)
