Forum Discussion
Mike_D4268
Mar 20, 2024Copper Contributor
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...
Mike_D4268
Mar 20, 2024Copper Contributor
Thanks NikolinoDE, but that did not work. That formula populated an array of five different numbers! I am looking for it to return a single number, 3.
Detlef_Lewin
Mar 20, 2024Silver Contributor
- Mike_D4268Mar 20, 2024Copper ContributorThanks Detlet Lewin, your =SUM formula was successful. I appreciate it! The user OliverScheurich provided a formula that also worked...