yogi_Sum Across Multiple Cell Criteria

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #529    May 5, 2012     www.energyefficientbuild.com

user kurfodo said:
How to sum across multiple cell criteria 

I'd like to sum liability based on two conditions: status equals unsettled and per name. 

The input looks like the following table.

Status      Who         Liability

Unsettled Brent  $46.72

Unsettled James $7.49

Unsettled James  $54.74

Settled James  -$10.00

The output should look something like:

Brent        $46.72

James        $62.23

Thanks!

------------------------------------------------------------------------------------------------------

following is a solution to the problem