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