Calculate standard error of mean, omitting cells with #DIV/0 errors

[obengsakbak]

I would please like to find a formula that calculates SEM for a range of cells while avoiding the cells with #div/0!. Thanks

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. "Excel formula and functions" is not a good title. I have updated it for you this time because you are a new member. --6StringJazzer

[AliGW]

You might want to update your profile to Office 365 (as in days of the year, which is correct), not Office 360 (degrees in a circle, which is incorrect).

Do you already have a formula that is working unless there are errors in the range? Have you tried changing the formulae giving the errors so that the errors don't appear?

For instance:

=B1/A1 might give a division error, so I can change it to this:

=IFERROR(B1/A1,"")

or:

=IFERROR(B1/A1,0)

[obengsakbak]

Thanks for updating my title

[obengsakbak]

Thanks Ali, I was able to get a formula to calculate the average while avoiding the DIV/0! error using the formula =AVERAGEIF(FG12:FZ12,"<>#DIV/0!"). I want to calculate the SEM too while avoiding cells with the DIV/0! error. The current formula I'm using to calculate the SEM is =STDEV(FG12:FZ12)/SQRT(GA12). I've tried to modify this formula to avoid the cells with the DIV/0! error but excel keeps telling me that the formula I'm using is wrong. Thanks very much for the help and I look forward to your reply.

[JeteMc]

Have you attempted to utilize what Ali said about using IFERROR (as in =IFERROR(formula,"") for the formula that populates cells FG12:FZ12)?
Let us know if you have any questions.

[obengsakbak]

Thanks very much. I was able to use =IFERROR(B1/A1,"") to solve the problem.