Quote Originally Posted by Pauleyb View Post
Okay, getting the ORs in a sumifs is not really supported (or at least I don't see an obvious solution). This brings us to SUMPRODUCT
=SUMPRODUCT(--(C2:C300="AppName"),(LEFT(A2:A300,2)="PC")+(LEFT(A2:A300,2)="WC"),NOT(ISERR((FIND("XP",K2:K300))))+NOT(ISERR((FIND("7",K2:K300)))),--(L2:L300<>"test"))
I was also tempted to use DCOUNT, but you said you did not want to use filtering. Not sure if that fits in your definition of DCOUNT or not.
I am getting #N/A when I use the below formula. I tried to adapt it to what I need but found there was a wrong column. I am trying to reference a separate sheet on the same workbook but am getting nothing. This is the 'true' formula that I am running:

=SUMPRODUCT(--(Summary!C2:C30000="Imprivata*"),(LEFT(Summary!A2:A30000,2)="PC")+(LEFT(Summary!A2:A30000,2)="WC"),NOT(ISERR((FIND("XP",Summary!I2:I30000))))+NOT(ISERR((FIND("7",SummaryI2:I30000)))),--(Summary!L2:L30000<>"test"))

I am not against using the filters I just don't want to use manual filter on the sheet since it's so huge it takes approx 1 minute to calculate.

It should return with 10,446 if ran correctly.