Sumproduct help

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

Hi everyone.

This formula was work great when i did have that Q1:Q5
range in it. and ideas on how i can make this woork.




=SUMPRODUCT(('Raw Data'!$AK$2:$AK$9938=B9)*('Raw Data'!
$G$2:$G$9938=$D$6)*('Raw Data'!
$F$2:$F$9938=$Q$1:$Q$5),'Raw Data'!$O$2:$O$9938)
 
Try this (untested, but you get the idea)


=SUMPRODUCT(('Raw Data'!$AK$2:$AK$9938=B9)*('Raw Data'!$G$2:$G$9938=$D$6)*
(ISNUMBER(MATCH('Raw
Data'!$F$2:$F$9938,$Q$1:$Q$5,0))),'RawData'!$O$2:$O$9938)
 
Its not working. I want the forumal to look in cell
Q1:Q5 and even if one number is a match to add them up..

I tested it and nothing happened. I also want it to sum
if 2 or 3 of the number match

Please Help
 
I am not clear what you're trying to do. What do you mean 'add them up'?
What is "them", o2:o9938?

I understood it that you are using a formula to sum o2:o9938 when cond1
cond2 AND the numbers in F2:f9938 match any number within Q1:Q5.

Also, what are your criteria for the matches? 1 is OK, then 2 or 3 are OK?
Not 4 or 5, then? I don't know how to easily work that in anyways, just
hoping you'll clarify so others might have an idea what you're talking
about.

To move forward, best to explain what you're trying to do and not only
answer the specific questions above....
 
Back
Top