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!
 
Can you attach a simple sample workbook showing what you are trying to do?
 
Back
Top