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, 02:29 PM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Hi,

You're using XL 2010 so this should work:

Code:

=IFERROR(AVERAGEIF(DO2:DO145,"<>0"),0)

Reply With Quote