Microsoft Office Forums - View Single Post - [Solved] formula divide by serio error

Thread: [Solved] formula divide by serio error

View Single Post

Old

04-18-2012, 12:56 PM

vthomeschoolmom vthomeschoolmom is offline

vthomeschoolmom is offline

vthomeschoolmom uses Windows 7 32bit

Windows 7 32bit vthomeschoolmom uses Office 2010 32bit

vthomeschoolmom uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Feb 2012

Posts: 23

vthomeschoolmom is on a distinguished road

Default

formula divide by serio error

=SUMIF(DO2

O145,"<>0")/COUNTIF(DO2

O145,"<>0")

If no value in the column is not zero, then I get a divide by zero error of course. How do I write this formula to have the value be ZERO in this case? I am a bit of an excel noob. Thanks

Reply With Quote