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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with SUMIF formula
if they are greater than .15 but less than 1.65
I guess you know that you're excluding both 0.15 and 1.65 from the calculation? One way: =SUMIF(competition!D1602:D2620,""&AB1)-SUMIF(competition!D1602:D1620,"="&AB2) -- Biff Microsoft Excel MVP "Iriemon" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with SUMIF formula
Try this:
Sumproduct((competition!D1602:D2620AB1)*(competit ion!D1602:D2620<AB2)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Iriemon" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with SUMIF formula
Forgot the last argument:
=Sumproduct((competition!D1602:D2620AB1)*(competi tion!D1602:D2620<AB2)*competition!D1602:D2620) -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Try this: Sumproduct((competition!D1602:D2620AB1)*(competit ion!D1602:D2620<AB2)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Iriemon" wrote in message ... 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 |
Reply |
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 |