average of single cell per line?

revsoupbone

New member
Joined
Jan 12, 2014
Messages
1
Reaction score
0
Points
0
I'm a fumbling beginner. I have a spreadsheet to track weekly meeting collections, attendance and expenses that generates a report I give monthly. I'm trying to figure out what formula to use to keep a running average on the number of people attending/ So cell i on the sheet is "Number attending" and cell K is to be the average of cell i to the number of line entries. So...each time I enter a number in cell i in a new line cell K automatically calculates the average number of attendees to date.

I'm also not adept at explaining, sorry!

Thanks for any help!
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
Can you attach a simple sample workbook showing what you are trying to do?
 
Top