AVERAGEIFS with Date Wildcards

[Fermented Reptile]

Hi all,

I've written a formula that returns the average based on two dates that a user inputs into a couple of cells. The formula looks like this:

Please Login or Register  to view this content.

The dates are on the Dashboard sheet in B13 and C13. The formula works fine when there are dates in the respective cells, my problem is when the cells are left blank or have the default value of "---"; in this instance I want to average everything, however I keep getting a #DIV/0! error.

Can anyone suggest where my formula is faulty?

TIA,

FermentedR

[Pete_UK]

The dates are really numbers, and you can't use the wildcard "*" to match them - hence there are no matches and you get the #DIV/0 error. Instead of using "*", try ">0".

Hope this helps.

Pete

[Fermented Reptile]

That works a treat. Much appreciated - thanks Pete!