J jeanie Nov 21, 2008 #1 I am new to excell and I am trying to get the sum of each months fuel expenses up until now.
G Gary''s Student Nov 21, 2008 #2 say our data in A1 thru B100: 8/1/2007 $134.00 9/1/2007 $109.00 10/1/2007 $176.00 11/1/2007 $117.00 12/1/2007 $122.00 1/1/2008 $126.00 2/1/2008 $123.00 3/1/2008 $168.00 4/1/2008 $141.00 5/1/2008 $127.00 6/1/2008 $140.00 7/1/2008 $151.00 8/1/2008 $180.00 9/1/2008 $172.00 10/1/2008 $167.00 11/1/2008 $181.00 Now we only want year-to-date. In another cell: =SUMPRODUCT((YEAR(A1:A100)=2008)*(B1:B100)) displays 1676 because 2007 values are excluded
say our data in A1 thru B100: 8/1/2007 $134.00 9/1/2007 $109.00 10/1/2007 $176.00 11/1/2007 $117.00 12/1/2007 $122.00 1/1/2008 $126.00 2/1/2008 $123.00 3/1/2008 $168.00 4/1/2008 $141.00 5/1/2008 $127.00 6/1/2008 $140.00 7/1/2008 $151.00 8/1/2008 $180.00 9/1/2008 $172.00 10/1/2008 $167.00 11/1/2008 $181.00 Now we only want year-to-date. In another cell: =SUMPRODUCT((YEAR(A1:A100)=2008)*(B1:B100)) displays 1676 because 2007 values are excluded
S Shane Devenshire Nov 21, 2008 #3 Hi, Suppose your expense are in A1:A12 but there is no data for Nov or Dec =SUM(A1:A12) If this helps, please click the Yes button Cheers, Shane Devenshire
Hi, Suppose your expense are in A1:A12 but there is no data for Nov or Dec =SUM(A1:A12) If this helps, please click the Yes button Cheers, Shane Devenshire
