Jerry W. Lewis wrote:
I am confused. D3,D4,D5 etc refer to cells in a column (D), not a row. Your
original formula seemed primarily concerned with row 1 and seemed to be
trying to put the result in A2, not C3. What is in A4 that the original
formula used? What adjustment are you performing with A1? Your subject
asked about averaging 17 cells, but now you mention averaging n cells; where
is n obtained?

Jerry

Copying off the net is not the same as copying from Excel. You either need
to describe what you expect the cell to do, or point to the web address where
[quoted text clipped - 22 lines]

Jerry

Hit me on the head and call me stupid ! I got a little flustered when typing

I am working out the average hrs of employees for the WTD (Working time
directive). Currently attempting to work out the last 17 weeks, however,
later this may turn to be 26 weeks if "Opt out" is agreed.

Cell A1 = number of last weeks to average, ignoring blanks cells
Cell A3 = Name
Cell B3 = Result of last 17 weeks
Cell C3 = Hrs
Cell D3 = Hrs
Cell E3 = Hrs
Etc, Etc

If it is not possible to enter a variable in A1, then I will go with the
fixed 17 weeks

Hope this is clearer?

Regards

Brian



Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200511/1