SUMPRODUCT

[Guest]

I am using this formula:
=SUMPRODUCT(('PR Tracking'!$A$7:$A$2500="567W")*('PR Tracking'!$J$7:$J$2500="capital")*('PR Tracking'!M$7:M$2500))

It works great, but. I need to know how to have it look for more than one value in
'PR Tracking'!$A$7:$A$2500. i.e. I need it to find 567W and 668N. I have tried everything I know to get it to work and I have had no luck. Any suggestions would be greatly appreciated!!!

 

[Norman Harker]

Hi frustrated!

Try:

=SUMPRODUCT(('PR Tracking'!$A$7:$A$2500={"567W","668N"})*('PR
Tracking'!$J$7:$J$2500="capital")*('PR Tracking'!M$7:M$2500))

The array parentheses are use to construct the OR that you require.

 

[Norman Harker]

Hi frustrated!

Thanks for thanks is always appreciated and shows Google searchers
that a suggested solution works.