=LOOKUP(9.99999999999999E+307,$X$5:$X$100)/COUNT($X$5:$X$100)

"Frank Kabel" wrote in message
...
Hi
untested but try
=VLOOKUP(9.9999999E307,$X5:$X100,1)/SUMPRODUCT(--($X$5:$X$100""))


--
Regards
Frank Kabel
Frankfurt, Germany

Thanks, Frank, it works!!

I now have another, related question. Column X is calculating a
cumulative total. I want to be able to calculate the average weekly
total. I was using this formula

=OFFSET($x,COUNTA($x5:$x56)-1,0)/COUNTA($x5:$x56)

So I'm trying to take the result of your VLOOKUP formula and divide
it
by the total number of weeks for which we have data. Can I do
something like that with the VLOOKUP?

Thanks, Nan


---
Message posted from http://www.ExcelForum.com/