| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I average a column?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I average a column?
Thanks heaps for that!
-- Why work on Wednesday and stuff up two good long weekends "Gary''s Student" wrote: Very similar to Lotus. Use: =AVERAGE(B3:B100) AVERAGE() ignores blanks, but includes any true zeros if you have them -- Gary''s Student "Jim Ryan" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I average a column?
Very similar to Lotus. Use:
=AVERAGE(B3:B100) AVERAGE() ignores blanks, but includes any true zeros if you have them -- Gary''s Student "Jim Ryan" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I average a column?
You are very welcome
-- Gary's Student "Jim Ryan" wrote: Thanks heaps for that! -- Why work on Wednesday and stuff up two good long weekends "Gary''s Student" wrote: Very similar to Lotus. Use: =AVERAGE(B3:B100) AVERAGE() ignores blanks, but includes any true zeros if you have them -- Gary''s Student "Jim Ryan" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Weighed average if the adjecent column contains blanks | Excel Discussion (Misc queries) | |||
| Average the Last Five Cells in a Column | Excel Worksheet Functions | |||
| I need to find the Average from Column A - but Reference Column B | Excel Worksheet Functions | |||
Linear Mode
