using fiscal year calculations in a formula

M

mePenny

I have a fuel intake sheet i have to take care of. I can figure the calendar
year easily but i don't know how to figure in the fiscal year. The book
consists of the following:

date, type of fuel, amount, price (a,b,c,d)

What I need is to find the total of unleaded during the fiscal year plus
total of diesel during fiscal year.

In the calendar year i'm using the formula:
=sumif(b:b,"u",c:c) for unleaded
=sumif(b:b,"d",c:c) for diesel

I'm hoping this isn't too confusing.

Any and all help is truly appreciated.

mePenny
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Still in need of help 3
Averaging Fiscal / Calendar year Fuel 11
calendar year versus fiscal year 4
Fiscal Year Formula 7
Calculating Dates Within Fiscal Year 2
Date formula: return Quarter and Fiscal Year of a date 7
Formula to determine Fiscal Year 3
Fiscal Year in date field 6

Top