COUNTIFS to count if data values in Column B are higher than the data values in Column A

Question

Hello,&nbsp;Can someone help me with the formula needed to count the number of occurrences, wherein, the data listed in Column B is higher than the data listed in Column A?&nbsp;The answer in the below example would be, 3.&nbsp;&nbsp;

nikolinode · Answer

Mike_D4268&nbsp;Your attempt at using the COUNTIFS function is almost correct, but it needs a slight adjustment to work properly. COUNTIFS requires multiple conditions to be specified separately, and you cannot directly compare two ranges like B4:B8&gt;A4:A8 within a single condition. Instead, you can use two separate conditions to achieve your goal. Here's the correct formula:=COUNTIFS(B4:B8,"&gt;"&amp;A4:A8)This formula will count the number of occurrences where the values in Column B are higher than the corresponding values in Column A within the specified range.&nbsp;My answers are voluntary and without guarantee!&nbsp;Hope this will help you.&nbsp;Was the answer useful? Mark as best response and like it!This will help all forum participants.

mike_d4268 · Answer

NikolinoDE&nbsp;Thanks NikolinoDE, but that did not work. &nbsp;That formula populated an array of five different numbers! &nbsp;I am looking for it to return a single number, 3.&nbsp;

oliverscheurich · Answer

Mike_D4268&nbsp;=SUMPRODUCT(N(A4:A8&lt;B4:B8))&nbsp;SUMPRODUCT returns the intended result in my sheet.

detlef_lewin · Answer

Mike_D4268&nbsp;Try this.=SUM(--(A4:A8&lt;B4:B8))&nbsp;

mike_d4268 · Answer

Thanks OliverScheurich, your SUMPRODUCT formula accomplished my goal. I appreciate it. The user Detlef Lewin's formula also worked.

Forum Discussion

COUNTIFS to count if data values in Column B are higher than the data values in Column A

Share

Resources