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

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

totals debit amounts for the Ck payment method.

"Denise" wrote in message
...
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(E2:E500,"C",G2:G500)


Regards,

Peo Sjoblom

"Denise" wrote:

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

One way:

=SUMPRODUCT((E1:E100="V")*(G1:G100-F1:F100))

Tim C

"Denise" wrote in message
...
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