| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Matching Values from an Array | Excel Worksheet Functions | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cel | Excel Discussion (Misc queries) | |||
| I want the greater number of 2 cells to show in a separate cell | Excel Discussion (Misc queries) | |||
| if greater then 99 then 1 if greater then 199 then two | Excel Worksheet Functions | |||
Threaded Mode
