M
mePenny
I posted this prior with no final answer to my question.
I'm looking for a formula that can help sort calendar from fiscal year. I'm
hoping this is enough info. If not please let me know.
mePenny
HEADINGS ONLY:
A4 - DATE
B4 - TYPE OF FUEL (U = UNLEADED, D = DIESEL)
C4 - GALLON AMOUNT OF FUEL DELIVERED
D4 - PRICE PER GALLON AT TIME OF DELIVERY
ENTRIES ONLY:
A6 - A24 ARE THE ENTRIES OF FUEL DELIVERED
G5 - CALENDAR YEAR (HEADING ONLY)
G6 - (WORD ONLY) UNLEADED H6 - (NEED FORMULA HERE)
G7 - (WORD ONLY) DIESEL H7 - (NEED FORUMLA HERE)
G9 - FISCAL YEAR (HEADING ONLY)
G10 - (WORD ONLY) UNLEADED H10 - (NEED FORMULA HERE)
G11 - (WORD ONLY) DIESEL H11 - (NEED FORMULA HERE)
Okay, what i'm looking for is the formulas for cells H6,H7,H10,H11
H6,H7: I need to pull the amount of fuel delivered in the current calendar
year (January to December) for each type of fuel (H6 unleaded, H7 diesel)
H10,H11: I need to pull the amount of fuel delivered in the current fiscal
year (7/1/09 - 6/30/10) for each type of fuel (H10 unleaded, H11 diesel)
I'm looking for a formula that can help sort calendar from fiscal year. I'm
hoping this is enough info. If not please let me know.
mePenny
HEADINGS ONLY:
A4 - DATE
B4 - TYPE OF FUEL (U = UNLEADED, D = DIESEL)
C4 - GALLON AMOUNT OF FUEL DELIVERED
D4 - PRICE PER GALLON AT TIME OF DELIVERY
ENTRIES ONLY:
A6 - A24 ARE THE ENTRIES OF FUEL DELIVERED
G5 - CALENDAR YEAR (HEADING ONLY)
G6 - (WORD ONLY) UNLEADED H6 - (NEED FORMULA HERE)
G7 - (WORD ONLY) DIESEL H7 - (NEED FORUMLA HERE)
G9 - FISCAL YEAR (HEADING ONLY)
G10 - (WORD ONLY) UNLEADED H10 - (NEED FORMULA HERE)
G11 - (WORD ONLY) DIESEL H11 - (NEED FORMULA HERE)
Okay, what i'm looking for is the formulas for cells H6,H7,H10,H11
H6,H7: I need to pull the amount of fuel delivered in the current calendar
year (January to December) for each type of fuel (H6 unleaded, H7 diesel)
H10,H11: I need to pull the amount of fuel delivered in the current fiscal
year (7/1/09 - 6/30/10) for each type of fuel (H10 unleaded, H11 diesel)