| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with SUMIF formula
Trying to get SUMIF formula to sum the values between D:1602 & D2620 if they
are greater than .15 but less than 1.65. Unfortunately, the formula below is giving me zero for the result. (AB1 = .15, AB2 = 1.65). The idea is to be able to change the min and max in AB 1 & 2 and have it sum only those cells between the values) =SUMIF(competition!D1602:D2620,OR(competition!D160 2:D2620AB1,competition!D1602:D1620<AB2)) Thanks for any help! Irie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| multiply formula where 1 cell has a (sumif) formula as a result | Excel Worksheet Functions | |||
| Formula using SUMIF & IF | Excel Worksheet Functions | |||
| Is there a MAXIF formula similar to the SUMIF formula? | Excel Discussion (Misc queries) | |||
| SumIF Formula | Excel Worksheet Functions | |||
Threaded Mode
