I have Greater than, I need less than also
 

The formula I am working with gives me a total number of items per
department, who's sales rating is above 83.99%. I am using the exact same
formula for items that rate above 93.99%. The problem is that this formula is
grabbing EVERYTHING above 83.99%. I need it to grab only from 84% to 93.99%.
Can someone help me define this please?

=SUMPRODUCT(--('SKU Data'!$A$2:$A$25000=B16),--('SKU
Data'!$G$2:$G$2500083.99))

I have Greater than, I need less than also
 

Just use the same idea to add the extra parameter. Trial and error is a good
way to learn.

--
Don Guillett
SalesAid Software

"rlee1999" wrote in message
...
The formula I am working with gives me a total number of items per
department, who's sales rating is above 83.99%. I am using the exact same
formula for items that rate above 93.99%. The problem is that this formula
is
grabbing EVERYTHING above 83.99%. I need it to grab only from 84% to
93.99%.
Can someone help me define this please?

=SUMPRODUCT(--('SKU Data'!$A$2:$A$25000=B16),--('SKU
Data'!$G$2:$G$2500083.99))

I have Greater than, I need less than also
 

Untested but should work,
=SUMPRODUCT(--('SKU Data'!$A$2:$A$25000=B16),--('SKU
Data'!$G$2:$G$2500083.99))-SUMPRODUCT(--('SKU
Data'!$A$2:$A$25000=B16),--('SKU
Data'!$G$2:$G$25000<94))
Regards,
Alan.
"rlee1999" wrote in message
...
The formula I am working with gives me a total number of items per
department, who's sales rating is above 83.99%. I am using the exact same
formula for items that rate above 93.99%. The problem is that this formula
is
grabbing EVERYTHING above 83.99%. I need it to grab only from 84% to
93.99%.
Can someone help me define this please?

=SUMPRODUCT(--('SKU Data'!$A$2:$A$25000=B16),--('SKU
Data'!$G$2:$G$2500083.99))

try this
=SUMPRODUCT(--('SKU Data'!$A$2:$A$25000=B16),--('SKU
Data'!$G$2:$G$25000=84%),--('SKU
Data'!$G$2:$G$25000<=93.99%))
:)