DAVERAGE With criteria within the formula

Morning All,

I have a table of receipts monitoring fuel bought for a fleet of vehicles i would like another table to run a average fuel cost of the month. The DAVERAGE function seems to do what i need it to do, but the problem I have is that the criteria has to be set in cells, rather than in the formula itself. Is it possible to put the cirtiera directly into the Formula rather than have a table listed somewhere on the spreadsheet?

Thanks in advance for the help

Perhaps AVERAGEIFS as an alternative?

Thanks John for the quick reply,

That looks like it could work, im using a formula something like his "=AVERAGEIFS(G2:G6,F2:F6,">=01/01/2016",F2:F6,"<=31/01/2016")" , off course this has one tiny problem is that it wouldn't account for a leap year in. Would you know how i could get around this fact? is there a way i can simplify it to simply look for month, rather than a date range?

Regards
Michael

Not sure I understand about leap year.

You have this "flexibility" ...

=AVERAGEIFS(G2:G6,F2:F6,">=" &B1,F2:F6,"<="&EOMONTH(B1,0))

B1= Date e.g 01/01/2016 so you could have dates (months) as column headings (01/01/2016, 01/02/2016 etc) formatted as "mmm-yy" for example

Does this help?

Thanks again.

the problem with the leap year was the extra day in February. but using EOMONTH has fixed that.

Thanks
Michael