# Sumproduct - Or help

#### jedibrown

##### Board Regular
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

### 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
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
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
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.

Replies
7
Views
80
Replies
2
Views
113
Replies
5
Views
133
Replies
5
Views
133
Replies
7
Views
120