AVERAGE only IF a number?

[Pedro's PhD]

Hi Everyone,

I need to average cells B13, E13, H13. However, sometimes the cells contain #N/A so I need it to ignore the cell when non numerical data is displayed.

Likewise I need to do the same with STDEV.

Thanks..... Pedro

 

[macro boy]

Hi Pedro,

Try This = Averageif(B13:H13,">0",B13:H13)

It ignore considers valeues > 0

Regards, Ravi

 

[Pedro's PhD]

Hi Ravi,

My trouble is I can't input the range B13:H13 as need it to calculate just the specific cells B13, E13, H13 as I have other data in C13, F13, I13 I do not want it to include in the formula?

Thanks.... Pedro