Mix COUNTIF and SUMPRODUCT?

wk9128 · #1 01-07-2021, 01:15 AM

Try , Array formula

=COUNT(0/N((LEFT(I19:I23,3)="ABC")*(MOD(ROW(I19:I23),2)=1)* (J19:J23="Here")))

SoMany · #2 01-10-2021, 02:47 AM

Both work, thanks all.

I changed the first equation a little, in my head it makes more since to change the parenthesis. If this can run into issues, please let me know. Otherwise, problem solved.

=SUMPRODUCT(--(LEFT(I18:I28,3)="ABC")*(ISODD(MID(I18:I28,4,3)))* (J18:J28="Here"))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumproduct	arndts	Excel	6	01-09-2019 01:10 AM
Issue with SumProduct	Perceptus	Excel	1	03-13-2015 06:23 AM
Countifs and Sumproduct	Algo	Excel	6	11-13-2012 07:44 AM
sumproduct??	jer	Excel	9	10-14-2012 10:00 AM
Sumproduct	angie.chang	Excel	3	06-14-2012 10:00 AM