Conditional Sum Formula

Anoop Mishra

Hello,

I am trying to insert a formula for extended price of projects that auto calculates for close rating of A, B and C.

Any help is much appreciated.

Brian Campbell

Hello,

Sumif should do this

=SUMIF(Select Close Rating Data range and make sure to lock it, Type in Letter you are evaluating (Example "A" just switch letter for whichever column), Select Range of $ Amount Column)

Let me know if you need additional help building this