Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF or SUMIFS
Here is what I have
Col A Col B Col C 1310 3 3,463.00 1315 3 740 1330 3 1369 3 -178 1375 3 -105 1640 3 110 135 4 1310 4 1,460.00 1315 4 1,521.00 1375 4 -65 1310 6 3,284.96 I am trying to figure out a way to add column C to a new cell if Column A is between 1310 and 1369. Any suggestions?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF or SUMIFS
On Jan 29, 2:14 pm, Jeff wrote:
Here is what I have Col A Col B Col C 1310 3 3,463.00 1315 3 740 1330 3 1369 3 -178 1375 3 -105 1640 3 110 135 4 1310 4 1,460.00 1315 4 1,521.00 1375 4 -65 1310 6 3,284.96 I am trying to figure out a way to add column C to a new cell if Column A is between 1310 and 1369. Any suggestions?? Using the data above in a spreadsheet the formula would look something like this:- =SUMIF(A3:A13,"<1369",C3:C13)-SUMIF(A3:A13,"<=1310",C3:C13) If you need more details, theres more of an explanation he http://www.vertex42.com/ExcelTips/ex...-function.html HTH Regards, Matt Richardson http://teachr.blogspot.com |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF or SUMIFS
On Jan 29, 2:14 pm, Jeff wrote:
Here is what I have Col A Col B Col C 1310 3 3,463.00 1315 3 740 1330 3 1369 3 -178 1375 3 -105 1640 3 110 135 4 1310 4 1,460.00 1315 4 1,521.00 1375 4 -65 1310 6 3,284.96 I am trying to figure out a way to add column C to a new cell if Column A is between 1310 and 1369. Any suggestions?? Try this:- =SUMIF(A3:A13,"<1369",C3:C13)-SUMIF(A3:A13,"<=1310",C3:C13) Also have a butchers at this site which explains more on how to use SUMIF in this way (ie including greater than or equal to, less than or equal to etc etc) http://www.vertex42.com/ExcelTips/ex...-function.html HTH. Regards, Matt Richardson http://teachr.blogspot.com |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF or SUMIFS
Hi,
Maybe This one excludes 1310 & 1369 =SUMIF(A2:A12,"1310",C2:C12)-(SUMIF(A2:A12,"=1369",C2:C12)) This one includes those numbers =SUMIF(A2:A12,"=1310",C2:C12)-(SUMIF(A2:A12,"1369",C2:C12)) Mike "Jeff" wrote: Here is what I have Col A Col B Col C 1310 3 3,463.00 1315 3 740 1330 3 1369 3 -178 1375 3 -105 1640 3 110 135 4 1310 4 1,460.00 1315 4 1,521.00 1375 4 -65 1310 6 3,284.96 I am trying to figure out a way to add column C to a new cell if Column A is between 1310 and 1369. Any suggestions?? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF or SUMIFS
If you're using Excel 2007:
Inclusive of 1310 and 1369 =SUMIFS(C2:C12,A2:A12,"=1310",A2:A12,"<=1369") Excluding 1310 and 1369: =SUMIFS(C2:C12,A2:A12,"1310",A2:A12,"<1369") -- Biff Microsoft Excel MVP "Jeff" wrote in message ... Here is what I have Col A Col B Col C 1310 3 3,463.00 1315 3 740 1330 3 1369 3 -178 1375 3 -105 1640 3 110 135 4 1310 4 1,460.00 1315 4 1,521.00 1375 4 -65 1310 6 3,284.96 I am trying to figure out a way to add column C to a new cell if Column A is between 1310 and 1369. Any suggestions?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can SUMIFS use the OR function? | Excel Worksheet Functions | |||
SUMIFS | Excel Discussion (Misc queries) | |||
SUMIFS and OR | Excel Worksheet Functions | |||
SUMIFS error | Excel Discussion (Misc queries) | |||
SumIfs | Excel Discussion (Misc queries) |