View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
rlh rlh is offline
external usenet poster
 
Posts: 2
Default TEMPLATE FOR TOTAL DEBT AND MONTHLY PAYMENTS

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?