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