Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging Fiscal / Calendar year Fuel
I have the following formula's to seperate out fuel (u=unleaded, d=diesel)
for Fiscal (7/1/09 - 6/30/09) and Calendar year. I'm looking for an average of gallons of fuel formula for the Fiscal and Calendar year. Can anyone help? mePenny Calendar =SUMPRODUCT((YEAR(A6:A100)=2009)*(B6:B100="u")*C6: C100) =SUMPRODUCT((YEAR(A6:A101)=2009)*(B6:B101="d")*C6: C101) Fiscal =SUMPRODUCT(((YEAR(A6:A100)=2009)*(MONTH(A6:A100) =7)+(YEAR(A6:A100)=2010)*(MONTH(A6:A100)<=6))*(B6: B100="u")*C6:C100) =SUMPRODUCT((TEXT(A6:A100,"yyyymm")="200907")*(TE XT(A6:A100,"yyyymm")<="201006")*(B6:B100="d")*C6:C 100) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
calendar year versus fiscal year | Excel Discussion (Misc queries) | |||
Define fiscal year | Excel Worksheet Functions | |||
Help dealing with a fiscal year rather than a calendar year | Excel Worksheet Functions | |||
Fiscal Year Calculation | Excel Worksheet Functions | |||
Fiscal Calendar | Excel Discussion (Misc queries) |