| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to make a nested SUMIF possible
I am trying to sum a column ("S") based on fulfilling 2 criteria in 2
other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a formula rather than a DSUM since my criteria changes in 2 different ways; Column C follows a cell reference, and Column O follows months 1 - 12. Suggestions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a nested SUMIF possible
maybe
=sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22) -- Don Guillett SalesAid Software "paul" wrote in message oups.com... I am trying to sum a column ("S") based on fulfilling 2 criteria in 2 other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a formula rather than a DSUM since my criteria changes in 2 different ways; Column C follows a cell reference, and Column O follows months 1 - 12. Suggestions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a nested SUMIF possible
Thanks... I tried sumproduct and received the #num error or wacko
results with SUM(IF(... =SUMPRODUCT((JDE=A24)*(Month=4)*USD) JDE = Column C Month = Column O USD = summing all $$$ Month = discreet value to be changed by cell. Don Guillett wrote: maybe =sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22) -- Don Guillett SalesAid Software "paul" wrote in message oups.com... I am trying to sum a column ("S") based on fulfilling 2 criteria in 2 other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a formula rather than a DSUM since my criteria changes in 2 different ways; Column C follows a cell reference, and Column O follows months 1 - 12. Suggestions? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a nested SUMIF possible
Thanks!!!!!!!!!!!!!!
I guess it did not like my "NAMED" ranges... It worked when I used the actual cell references. =SUMPRODUCT(('Raw Data'!$C$2:$C$6270=$A2)*('Raw Data'!$O$2:$O$6270=1)*'Raw Data'!$S$2:$S$6270) Don Guillett wrote: maybe =sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22) -- Don Guillett SalesAid Software "paul" wrote in message oups.com... I am trying to sum a column ("S") based on fulfilling 2 criteria in 2 other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a formula rather than a DSUM since my criteria changes in 2 different ways; Column C follows a cell reference, and Column O follows months 1 - 12. Suggestions? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a nested SUMIF possible
Thanks!!!!!!!!!!!!!!
I guess it did not like my "NAMED" ranges... It worked when I used the actual cell references. =SUMPRODUCT(('Raw Data'!$C$2:$C$6270=$A2)*('Raw Data'!$O$2:$O$6270=1)*'Raw Data'!$S$2:$S$6270) Don Guillett wrote: maybe =sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22) -- Don Guillett SalesAid Software "paul" wrote in message oups.com... I am trying to sum a column ("S") based on fulfilling 2 criteria in 2 other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a formula rather than a DSUM since my criteria changes in 2 different ways; Column C follows a cell reference, and Column O follows months 1 - 12. Suggestions? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to make a nested SUMIF possible
Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "paul" wrote in message oups.com... Thanks... I tried sumproduct and received the #num error or wacko results with SUM(IF(... =SUMPRODUCT((JDE=A24)*(Month=4)*USD) JDE = Column C Month = Column O USD = summing all $$$ Month = discreet value to be changed by cell. Don Guillett wrote: maybe =sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22) -- Don Guillett SalesAid Software "paul" wrote in message oups.com... I am trying to sum a column ("S") based on fulfilling 2 criteria in 2 other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a formula rather than a DSUM since my criteria changes in 2 different ways; Column C follows a cell reference, and Column O follows months 1 - 12. Suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Eliminating Duplicate GROUPS of Styles | Excel Worksheet Functions | |||
| nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
| make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| How Do I created a nested sumif - if this column has this and thi. | Excel Worksheet Functions | |||
Linear Mode
