View Single Post
  #1   Report Post  
Denise
 
Posts: n/a
Default Need a simple formula please

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