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
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