Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Am looking for template allows for list of all monthly bills,i.e. credit
card,loans etc,and total amount of all combined.attempting to determine if consolodation is fesabile? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is it not easier just to list the type bill in column A and the amount in
column B, then sum all the amounts instead of looking for a template? If you have more than one type, ie 3 credit cards, 2 car loans, etc., then put a category for each item, ie CC = Credit Card, Car = Car Loan, Mtg = Mortgage. That way you can use SUMIF to total each category and also use SUM to indicate the total sum of all bills. "rlh" wrote: Am looking for template allows for list of all monthly bills,i.e. credit card,loans etc,and total amount of all combined.attempting to determine if consolodation is fesabile? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks,just learning my way around internet,etc.Your response was clear,and
easy to follow. "WLMPilot" wrote: Is it not easier just to list the type bill in column A and the amount in column B, then sum all the amounts instead of looking for a template? If you have more than one type, ie 3 credit cards, 2 car loans, etc., then put a category for each item, ie CC = Credit Card, Car = Car Loan, Mtg = Mortgage. That way you can use SUMIF to total each category and also use SUM to indicate the total sum of all bills. "rlh" wrote: Am looking for template allows for list of all monthly bills,i.e. credit card,loans etc,and total amount of all combined.attempting to determine if consolodation is fesabile? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|