Hello Folk,
I have been picking my minds for a few days. I tried using conditional Sum.
ex.
Date Type Tax Total
02/05/2008 Gas .12 10.00
02/09/2008 Books .14 12.00
03/10/2008 Food .10 1.00
03/18/2008 Tickets .12 3.00
03/19/2008 Gas .15 4.00
i want another page to add total of each month expenses just all of feb, then march, i know i can add each one up, but an on going total . help please. i came up with
=SUM(IF(Expenses!$A$6:$A$2300>DATEVALUE("2/1/2008"),IF(Expenses!$A$6:$A$2300<"02/30/08",Expenses!$F$6:$F$2300,0),0))
but, it ends up adding everything together not just the dates btw 02/01/2008 - 02/31/2008
Bookmarks