Thread: #value! error trying to create a simple dynamic named range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Janis Janis is offline
external usenet poster
  
Posts: 360
Default #value! error trying to create a simple dynamic named range
The lastsix named range is the range I want to average each week but I have
to insert a column so it moves over one if it isn't a dynmic range.

LastSix=OFFSET(Sheet2!AF2,ROW( ), COUNTA(Sheet2!2:2)-6,1,6)

My formula to average each cell in the dynamic column.

=IF(SUM(LastSix)=0,0,ROUNDUP(SUM(LastSix)/COUNTIF(LastSix,"0"),2))


This will be used to build a report from an Access download and as much as
can be dynamic the better.

tia,
Reply With QuoteReply With Quote