Forum Discussion

Mike_D4268's avatar
Mike_D4268
Copper Contributor
Mar 20, 2024

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

Hello,   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?   The answer in the below...
excel
Excel on Mac
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 20, 2024

Mike_D4268 

=SUMPRODUCT(N(A4:A8<B4:B8))

 

SUMPRODUCT returns the intended result in my sheet.

  • Mike_D4268's avatar
    Mike_D4268
    Copper Contributor
    Mar 20, 2024
    Thanks OliverScheurich, your SUMPRODUCT formula accomplished my goal. I appreciate it. The user Detlef Lewin's formula also worked.

Resources