Home |
Search |
Today's Posts |
#1
|
|||
|
|||
SUM Function Question
I'm looking for a formula to Sum a column based on criteria from two other
columns. I have five columns: Project Name, Actual Cost, Division, Phase. I want to write a formula to Sum the Actual Cost of the projects per division, per phase. For instance, I want to know the "Total Actual Cost" for all projects in the AppDev division that are active. I've tried using the Sum and SumIf functions, but can't quite see to find the right combination. Could someone assist me in writing a formula to do this? Thanks, John |
#3
|
|||
|
|||
First, I think I'd recommend a Pivot Table
http://peltiertech.com/Excel/Pivots/pivotstart.htm rather than functions. However, you could use =SUMPRODUCT(B1:B1000,--(C1:C1000="AppDev"),--(D1:D1000="Active")) For an explanation of the -- operators, see http://www.mcgimpsey.com/excel/doubleneg.html In article , "John" <john(dot)cole(at)co(dot)riverside(dot)ca(dot)us wrote: I'm looking for a formula to Sum a column based on criteria from two other columns. I have five columns: Project Name, Actual Cost, Division, Phase. I want to write a formula to Sum the Actual Cost of the projects per division, per phase. For instance, I want to know the "Total Actual Cost" for all projects in the AppDev division that are active. I've tried using the Sum and SumIf functions, but can't quite see to find the right combination. Could someone assist me in writing a formula to do this? Thanks, John |
#4
|
|||
|
|||
It's not quite the same question, so rather than asking two questions in one
post, I decided to break it into two posts. I know the logic is slightly different, Count vs Sum, so I wanted to be sure I captured both. Thanks for your reply in this and the other post. I am going to try it now. John "Don Guillett" wrote in message ... Didn't you ask the same question 4 minutes ago? Why would changing the subject line help? -- Don Guillett SalesAid Software "John" <john(dot)cole(at)co(dot)riverside(dot)ca(dot)us wrote in message ... I'm looking for a formula to Sum a column based on criteria from two other columns. I have five columns: Project Name, Actual Cost, Division, Phase. I want to write a formula to Sum the Actual Cost of the projects per division, per phase. For instance, I want to know the "Total Actual Cost" for all projects in the AppDev division that are active. I've tried using the Sum and SumIf functions, but can't quite see to find the right combination. Could someone assist me in writing a formula to do this? Thanks, John |
#5
|
|||
|
|||
Thanks, you've been a big help!
It seems to calculate everything that I need. "JE McGimpsey" wrote in message ... First, I think I'd recommend a Pivot Table http://peltiertech.com/Excel/Pivots/pivotstart.htm rather than functions. However, you could use =SUMPRODUCT(B1:B1000,--(C1:C1000="AppDev"),--(D1:D1000="Active")) For an explanation of the -- operators, see http://www.mcgimpsey.com/excel/doubleneg.html In article , "John" <john(dot)cole(at)co(dot)riverside(dot)ca(dot)us wrote: I'm looking for a formula to Sum a column based on criteria from two other columns. I have five columns: Project Name, Actual Cost, Division, Phase. I want to write a formula to Sum the Actual Cost of the projects per division, per phase. For instance, I want to know the "Total Actual Cost" for all projects in the AppDev division that are active. I've tried using the Sum and SumIf functions, but can't quite see to find the right combination. Could someone assist me in writing a formula to do this? Thanks, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question on "Value" function | Excel Discussion (Misc queries) | |||
Another date function question | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions | |||
Grading Function Question... | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |