software

As an old Lotus user we just used @avg(b3..b100). Have set up a spreadsheet
to monitor bike rides - distances, time etc and would like to include a
running average in row 1.
Many thanks
--
Why work on Wednesday and stuff up two good long weekends

Thanks heaps for that!
--
Why work on Wednesday and stuff up two good long weekendsquot;Gary''s Studentquot; wrote:

gt; Very similar to Lotus. Use:
gt;
gt; =AVERAGE(B3:B100)
gt;
gt; AVERAGE() ignores blanks, but includes any true zeros if you have them
gt; --
gt; Gary''s Student
gt;
gt;
gt; quot;Jim Ryanquot; wrote:
gt;
gt; gt; As an old Lotus user we just used @avg(b3..b100). Have set up a spreadsheet
gt; gt; to monitor bike rides - distances, time etc and would like to include a
gt; gt; running average in row 1.
gt; gt; Many thanks
gt; gt; --
gt; gt; Why work on Wednesday and stuff up two good long weekends

Very similar to Lotus. Use:

=AVERAGE(B3:B100)

AVERAGE() ignores blanks, but includes any true zeros if you have them
--
Gary''s Studentquot;Jim Ryanquot; wrote:

gt; As an old Lotus user we just used @avg(b3..b100). Have set up a spreadsheet
gt; to monitor bike rides - distances, time etc and would like to include a
gt; running average in row 1.
gt; Many thanks
gt; --
gt; Why work on Wednesday and stuff up two good long weekends

You are very welcome
--
Gary's Studentquot;Jim Ryanquot; wrote:

gt; Thanks heaps for that!
gt; --
gt; Why work on Wednesday and stuff up two good long weekends
gt;
gt;
gt; quot;Gary''s Studentquot; wrote:
gt;
gt; gt; Very similar to Lotus. Use:
gt; gt;
gt; gt; =AVERAGE(B3:B100)
gt; gt;
gt; gt; AVERAGE() ignores blanks, but includes any true zeros if you have them
gt; gt; --
gt; gt; Gary''s Student
gt; gt;
gt; gt;
gt; gt; quot;Jim Ryanquot; wrote:
gt; gt;
gt; gt; gt; As an old Lotus user we just used @avg(b3..b100). Have set up a spreadsheet
gt; gt; gt; to monitor bike rides - distances, time etc and would like to include a
gt; gt; gt; running average in row 1.
gt; gt; gt; Many thanks
gt; gt; gt; --
gt; gt; gt; Why work on Wednesday and stuff up two good long weekends