Total varies cells, need to put in one cell

[rjwebgraphix]

Hope I can explain this properly.....

I have a table that calculates how much was spent on what for a given day. Looks something like this.

A B C X Y Z
1 DATE | Purpose | Amount | Runing Daily | DAY | TOTAL
2| 8/28/06 | Brain for strawman |$1.00 | $1.00 | |
3| 8/28/06 | Heart for tinman |$1.00 | $2.00 | |
4| 8/28/06 | Courage for Lion |$1.00 | $3.00 | MON |$3.00
5| 8/29/06 | Shoes for Dorothy |$1.00 | $1.00 | |
6| 8/29/06 | Dog food for toto |$1.00 | $2.00 | TUE |$2.00
Hopefully that displays right when posted....

Cell X (Runing Daily total) is calculated by checking the date with the next cell down.
TOTAL is done in the same fashion

With this, you can see how the total could move, This week, maybe only one thing bought per day, next week maybe 3 things bought per day, thus the total column would change.

There is a possibility of 40 line items on a single sheet which would make for a REALLY LONG IF statement to check if this date, if that day and that date and 40 other dates are the same, then we'll put it on this date.

The other part of the sheet needs one total for each day of the week in a specific cell.

Any idea in a forumla How I can grab just the total? since the total can move?

Any help appreciated.

[rjwebgraphix]

Found another way I can possibly do this, but it's not working, another idea would be helpful....

This is what I have which fits more to the actual sheet.

=SUMIF(AA7:AA9,=AH7,X7:X9)

AA7:AA9 are dates, =AH7 should be the date to compare to, but that isn't working it does change so cant hard code it in formula, X7:X9 are what to add if the dates match.

If I change =AH7 to "=08/26/06" then it works, but it should just compare to cell AH7.

Any ideas?

[rjwebgraphix]

Oops, Got it, Didn't need the =AH7, just AH7 and it worked...

Thanks,
RJ