Need a simple formula please

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Column E is a notation of payment method.
Column F is any debit of funds for a patient's account
Column G is any credit of funds for a patient's account

Three types of payment V, Ck, Ch

Elsewhere in the sheet I wish to total the funds (all patient's, all rows)
taken in, by payment method.

=IF (E9=C, G9, 0)
=IF (E10=Ck, G10, 0)
=IF (E11=Ch, G11, 0)

If this is correct, it will only work row by row. How do I get the whole
column at once?

Thanks!

Denise
 
=SUMIF($E$2:$E$100,"Ck",$F$2:$F$100)

totals debit amounts for the Ck payment method.
 
Back
Top