|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 28th, 2009, 09:31 PM
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  2620,OR(competition!D160 22620AB1,competition!D16021620AB2))Thanks for any help! Irie 
|
|
#2
July 28th, 2009, 10:06 PM
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 2620,""&AB1)-SUMIF(competition!D16021620,"="&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 2620,OR(competition!D160 22620AB1,competition!D16021620AB2))Thanks for any help! Irie
|
|
#3
July 28th, 2009, 10:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMIF formula
Try this:
Sumproduct((competition!D1602 2620AB1)*(competit ion!D16022620AB2))-- 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 2620,OR(competition!D160 22620AB1,competition!D16021620AB2))Thanks for any help! Irie
|
|
#4
July 28th, 2009, 10:15 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help with SUMIF formula
Forgot the last argument:
=Sumproduct((competition!D1602 2620AB1)*(competi tion!D16022620AB2)*competition!D16022620)-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "RagDyer" wrote in message ... Try this: Sumproduct((competition!D1602 2620AB1)*(competit ion!D16022620AB2))-- 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 2620,OR(competition!D160 22620AB1,competition!D16021620AB2))Thanks for any help! Irie
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
