Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get year to date account of an expense listed in a colum
I am new to excell and I am trying to get the sum of each months fuel
expenses up until now. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get year to date account of an expense listed in a colum
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 -- Gary''s Student - gsnu200815 "jeanie" wrote: I am new to excell and I am trying to get the sum of each months fuel expenses up until now. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get year to date account of an expense listed in a colum
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 "jeanie" wrote: I am new to excell and I am trying to get the sum of each months fuel expenses up until now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want software that I can scan receipts for expense account | Excel Discussion (Misc queries) | |||
Annualize/ Estimate year-to-date from monthly expense | Excel Worksheet Functions | |||
Subtotal by Account (cash, liability, revenue, expense) in Excel? | Excel Worksheet Functions | |||
money deposited into an account with 6.5% interest-amount of year | New Users to Excel | |||
where can i find an expense account form | Charts and Charting in Excel |