Microsoft Office Forums - View Single Post - [Solved] Empty cells plotted as zero.

Thread: [Solved] Empty cells plotted as zero.

View Single Post

Old

03-04-2013, 01:44 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 7 32bit

Windows 7 32bit Kevin@Radstock uses Office 2010 32bit

Kevin@Radstock uses Office 2010 32bit

Office 2010 32bit

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

Hi ColinC

Try the averageif within the iferror.
FYI, you can format/pre-format a selection of cells to not show zero values. For example: General;;" or "0.000;;" etc. That way you can still see zero values elsewhere if required.

=IFERROR(AVERAGEIF(C13:C16,">0",C13:C16),"")

Reply With Quote