Hi

it depends a bit on what you consider the total owed for each card is ... is
it the addition of the jan + feb + mar (etc) "total owed" row, or is it the
last value in this row (i.e. if total owed for Jan is 10, Feb is 15, March
is 5 do you want to see 30 or 5 on the second worksheet?) - i've included
formulas for both scenarios below - the formula for the answer to be 30 is
scenario A and the one for the answer to be 5 is scenario B

for the total owed for the first card the formulas will be like
Scenario A:
=SUM(Sheet1!B3:M3)
where B3 is the cell holding the value for card 1, January amount and Sheet1
is the name of the worksheet (note, if you sheet name has spaces in it
you'll need to enclose the sheet name in single quotes, e.g. =SUM('owed on
cards'!B3:M3)
Scenario B:
=INDEX(B3:M3,1,COUNTIF(B3:M3,"<"))

just use the same structure but adjust the row numbers for the other cards.

Hope this helps
Cheers
JulieD



"Clink7" wrote in message
...
I am new to excel. I am trying to track over the course of the year, 3
credit
cards and how much I pay per month in interest, payments and the total I
owe.
I have a worksheet that is like this:

Jan Feb Mar Apr
Card 1
Total Owed
Pmt
Int

the other 2 cards are listed the same way.

I have a 2nd worksheet that lists the 3 cards and just the total amt owed
for each one. How can I keep this updated so that when I update the 1st
worksheet each month, the 2nd worksheet updates to the latest total amount
owed?