Hello peoples!
I'm trying to count the number of rows in a dataset where column A is something, B is something, C is something, D is not something, D is not something else, and column E > 0 OR F is something but I just can't get the result I want.
My actual dataset is a staggering 294,000 rows and 46 columns so here's a simplified version:
I've tried SUMPRODUCT((A2:A9="C")*((B2:B9>0)+(C2:C9="Helped"))) but this seems to double count where both criteria are met instead of just once.Please Login or Register to view this content.
The output should be 6, not 7.
sumproduct or.xlsx
Bookmarks