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