Thread: [Solved] Mix COUNTIF and SUMPRODUCT?
View Single Post
 
Old 01-05-2021, 03:00 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

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
File Type: xlsx Copy of MsForums_Purfleet.xlsx (9.7 KB, 12 views)
Reply With Quote