![]() |
#1
|
|||
|
|||
![]()
In sheet 3 there is a column of figures (col. C)which builds up over time. When a group of four consecutive cells all have values in them the values are averaged and appear in cell P9 in sheet 4
=IF(COUNTBLANK(C13:C16)>0,"",AVERAGE(C13:C16)) This is working O.K. I now want to plot these averages but have the problem of empty cells being plotted as zero instead of being ignored. =IF(Sheet3!P9>0,Sheet3!P9,NA()) I have had this problem before and have received advice from this forum concerning the NA() function. It has worked O.K. on similar programs but not this time. Help please. Colin. Last edited by ColinC; 03-01-2013 at 06:18 AM. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ubns | Excel Programming | 2 | 08-14-2012 02:01 AM |
![]() |
tinfanide | Word VBA | 2 | 04-10-2012 01:34 AM |
Apparently empty (blank) cells aren't empty | daymaker | Excel | 3 | 03-08-2012 03:41 PM |
Empty cells plotted as zero. | ColinC | Excel | 2 | 01-23-2012 08:02 AM |
![]() |
Hwyn | Excel Programming | 2 | 11-14-2011 11:44 AM |