SUM Function Question

[John]

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

 

[Don Guillett]

Didn't you ask the same question 4 minutes ago? Why would changing the
subject line help?

 

[JE McGimpsey]

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"),--(D11000="Active"))


For an explanation of the -- operators, see

http://www.mcgimpsey.com/excel/doubleneg.html

 

[John]

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

 

[John]

Thanks, you've been a big help!
It seems to calculate everything that I need.