Mix COUNTIF and SUMPRODUCT?

		Microsoft Office Forums > Microsoft Excel > Excel
Mix COUNTIF and SUMPRODUCT?

FAQ

Thread Tools

Display Modes

01-10-2021, 02:47 AM

SoMany

Windows 7 64bit Mix COUNTIF and SUMPRODUCT?

Office 2016

Advanced Beginner

Join Date: Oct 2016

Posts: 51

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:39 AM.