I think the iserror formula will be simpler if you already have the
spreadsheet set up. Just make sure that A3 - Y3 have =if(iserror(4
week average formula)," ",4 week average formula).
Dave O Wrote:
This solution may work for you- since you're using a simple average you
can change the formula to
SUMIF(range, "<0", range) / COUNTIF(range,"<0")
This sums non-zero values and divides by the number of non-zero
values.
Use this ONLY on a continuous range of numbers, because
COUNTIF(range,"<0") will count blank cells.
--
Randy Davis
------------------------------------------------------------------------
Randy Davis's Profile:
http://www.excelforum.com/member.php...o&userid=29973
View this thread:
http://www.excelforum.com/showthread...hreadid=496654