Sumproduct - Or help

jedibrown

Board Regular
Joined
Oct 17, 2011
Messages
136
Good afternoon,

I wondered if somebody could help me with my sumproduct formula please?

So far I have:

=SUMPRODUCT(((('Request Data'!H1:H6000<=C8)*('Request Data'!H1:H6000>=Weekly!D8)*('Request Data'!L1:L6000="standard")*('Request Data'!G1:G6000="axapro"))))

The problem is the last part - I want to say, ('Request Data'!G1:G6000="axapro" OR "axademo OR Config").

Is this possible please?

Help would be very much appreciated.

Thanks
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try

=SUMPRODUCT(--('Request Data'!H1:H6000<=C8),--('Request Data'!H1:H6000>=Weekly!D8),--('Request Data'!L1:L6000="standard"),--(ISNUMBER(MATCH('Request Data'!G1:G6000,{"axapro","axademo","Config"},0))))
 

jedibrown

Board Regular
Joined
Oct 17, 2011
Messages
136
Thanks - I have managed to work it out:

=SUMPRODUCT(((('Request Data'!H1:H6000<=C8)*('Request Data'!H1:H6000>=Weekly!D8)*('Request Data'!L1:L6000="standard")*((('Request Data'!G1:G6000="axapro")+('Request Data'!G1:G6000="axademo")+('Request Data'!G1:G6000="config"))))))

Thanks for your help.
 

T. Valko

Well-known Member
Joined
May 9, 2009
Messages
16,623
Thanks - I have managed to work it out:

=SUMPRODUCT(((('Request Data'!H1:H6000<=C8)*('Request Data'!H1:H6000>=Weekly!D8)*('Request Data'!L1:L6000="standard")*((('Request Data'!G1:G6000="axapro")+('Request Data'!G1:G6000="axademo")+('Request Data'!G1:G6000="config"))))))

Thanks for your help.
The ISNUMBER/MATCH version will be faster to calculate.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,414
Messages
5,571,970
Members
412,429
Latest member
brahmaiah
Top