Didn't tell me what I was looking for. Thanks for the try.

"Bernard Liengme" wrote:

Not sure I understand but when someone asks how to sum subject to multiple
criteria, one always thinks of SUMPRODUCT
For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Jeremy" wrote in message
...
I am trying to create a sum if formula that takes the given in Rows B and
places them in D given the Criteria in C matches that of A under the
Payable,
Billable or Burden in B. D1 is manual typed as Billable, payable or
burden.

Thank you

A B C D
1 Payable PAYABLE
2 M 10 M 10
3 S 20 D 20
4 D 30 S 30
5
6
7 Billable
8 M 15
9 S 25
10 D 35
11
12 Burden
13 M 6
14 S 12
15 D 18
16