Sumproduct - Or help

[jedibrown]

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

 

[VoG]

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]

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]

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.