Results 1 to 2 of 2

Thread: average of single cell per line?

  1. #1

    average of single cell per line?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Can you attach a simple sample workbook showing what you are trying to do?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •