I am creating a workbook that will track my credit card spending, since we
use our credit card for everything because we get travel points with it, we
also pay it off every month so this works for us. I would like to be able to
see where and how much of our money is being spend. Like I said I have a
workbook I am working on and the first page worked great with the formula I
have but when I copy and paste the formula into other worksheets in the book
it doesn't work, I'm sure I just have to change something.

I will tell you how this workbook operates, I have a worksheet with all my
regular merchants that we use on a regular basis then on another worksheet I
copy and paste the data from my credit card statement in CSV format into
the worksheet, the data takes up 3 columns "A" date, "B" amount spent, "C"
merchant in column "D" I have the merchants in alphabetical order
"E" I have the formula =SUMPRODUCT(('11-16-07 - 12-25-07'!F1:F300="A AND W
RESTAURANT")*('11-16-07 - 12-25-07'!E1:E300)

It works perfect when I copy and paste the formula and change the merchant
name BUT when I create another worksheet to use to paste next months
statement the formula doesn't work, I get all $0.00 in all cells.

What can I change so that this formula will work on every months
worksheet???

Thanks in advance