SumIf including both positive and negative numbers

[Schmaltzy72]

I have posted a small sample file for your reference and wondering if someone can help me out. I have a little experience in Excel and need help with a formula to see how this can be done.

In the attached file I have a Summary worksheet with 2 job numbers. What I would like to do is have this worksheet sum the total cost for these projects. I have a SUMIF formula in Row C on Summary page that give me the overall total cost. I would also like to have 2 columns to show me the specific totals of cost and of the credits separately in columns D and E on Summary page.

Let me know if there is a way to do this.

Shawn

[Norie]

Shawn

You could try SUMIFS.

For the cost: =SUMIFS(Cost!$C$3:$C$14,Cost!$B$3:$B$14,Summary!$B3, Cost!$C$3:$C$14, ">0")

For the credits: =SUMIFS(Cost!$C$3:$C$14,Cost!$B$3:$B$14,Summary!$B3, Cost!$C$3:$C$14, "<0")

[Schmaltzy72]

Thank you!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.