Thread
: [Solved]
Mix COUNTIF and SUMPRODUCT?
View Single Post
01-05-2021, 03:00 PM
Purfleet
Windows 10
Office 2019
Expert
Join Date: Jun 2020
Location: Essex
Posts: 345
I think i got all your criteria on this one
=SUMPRODUCT(--(LEFT(I19:I23,3)="ABC")*(ISODD(MID(I19:I23,4,3)*(J 19:J23="Here"))))
Attached Files
Copy of MsForums_Purfleet.xlsx
(9.7 KB, 12 views)
Purfleet
View Public Profile
Find all posts by Purfleet