Addition Formula

  • Thread starter Thread starter Chance
  • Start date Start date
C

Chance

I want to get a cell to add all the totals in a colum that
has the word Charge in the cell next to it.

Amount Payment Method
$200 Charge
$100 Credit
$300 Charge


Cell with formula = 400

Thanks for any help
Chance
 
Chance

Use SUMPRODUCT

=SUMPRODUCT((A2:A6)*(B2:B6="Charge"))

Andy
PS I make the answer 500
 
Use the SUMIF() formula. This will sum the values in the
amount column if Charge is in the payment column.


HTH,
JC
 
i asume "amount" is colum A ligne 1, then on colum C create the formula
=(B2="charge")*A2, this will give you 0 if the payment methode is not charge
and A1 if it is charge. you just annd sum(C:C) somewhere else. i do not
think you can do it in one cell, but who know maybe, if you find let me know
..
i hope it helped.
Kemal
(e-mail address removed)
 
Back
Top