Average ignoring blanks

[Gwill1983]

Hi all,

I have a formula which returns an average number of orders placed per weekday which works nicely. The only problem is that it take blanks into consideration so the average number is really low!

My formula is
{=AVERAGE(IF(WEEKDAY('Data Range')=2,'Data Range'))}

What do I need to add to this to ignore the blanks within the data range?

Thanks

Chris

 

[GFelts]

Could you use Averagifs? if there is a zero or a formula in the cell average will use it in its calculations BUT

If you want to calculate the average of only the values that meet certain criteria, use the ​

AVERAGEIF

function or the ​

AVERAGEIFS

function.

Hope this helps
G
​

 

[FormR]

What do I need to add to this to ignore the blanks within the data range?

Hi, you could also try:

={AVERAGE(IF(WEEKDAY('Criteria Range')=2,IF(ISNUMBER('Average Range','Average Range')))}