M Manesh New Member Oct 15, 2014 #1 Dear Chandoo Please refer to the fill that has been attached. I am trying to determine the number of times that the value in Column A is greater than the value in Column B The correct response should be 12. Your assistance is appreciated. Thank you. Best regards, M Attachments Countif.xlsx 9.5 KB · Views: 6
Dear Chandoo Please refer to the fill that has been attached. I am trying to determine the number of times that the value in Column A is greater than the value in Column B The correct response should be 12. Your assistance is appreciated. Thank you. Best regards, M
Hui Excel Ninja Staff member Oct 15, 2014 #2 =SUM(IF(A2:A25>B2:B25,1,0)) Ctrl+Shift+Enter or =SUMPRODUCT(--(A2:A25>B2:B25)) Enter
