View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rlee1999 rlee1999 is offline
external usenet poster
 
Posts: 23
Default 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))