Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Need simple multiply formula | Excel Worksheet Functions | |||
simple formula help | Excel Worksheet Functions | |||
Please Reply! I Need A Simple Formula | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |