Hi,

I have a weekly expenditure table in excel, in which I include how much I spend every day on FOOD or FOOD OUT, for example. Each day has a 2 columns - one for the cost of the expenditure (on the left) and one for the description (on the right), in which I type - FOOD, FOOD OUT, HOUSEHOLD, BEAUTY, etc to describe the cost.

I'm trying to figure out how to calculate the total amount of money I've spent on each of these expenses. I want this box to appear to the right of all the days of the week.

Can anyone help me?? I've looked everywhere and tried a few different things but I can't figure this one out!

Thanks,
Sarah

By the way, i'm using excel 2003.

1 MON TUES WED THUR
2 A B C D
3 $4 FOOD $6.56 FOOD OUT
4 $6 BEAUTY $101 RENT