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

Thread: [Solved] Mix COUNTIF and SUMPRODUCT?

View Single Post

Old

01-10-2021, 02:47 AM

SoMany

SoMany is offline

SoMany uses Windows 7 64bit

Windows 7 64bit SoMany uses Office 2016

SoMany uses Office 2016

Office 2016

Advanced Beginner

The original poster

Join Date: Oct 2016

Posts: 51

SoMany is on a distinguished road

Default

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"))

Reply With Quote