Microsoft Office Forums - View Single Post - [Solved] Mix COUNTIF and SUMPRODUCT?

Thread: [Solved] Mix COUNTIF and SUMPRODUCT?

View Single Post

Old

01-07-2021, 01:15 AM

wk9128

wk9128 is offline

wk9128 uses Windows 10

Windows 10 wk9128 uses Office 2007

wk9128 uses Office 2007

Office 2007

Novice

Join Date: Dec 2020

Posts: 1

wk9128 is on a distinguished road

Default

Try , Array formula

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

Reply With Quote