Saturday, May 5, 2012

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