+ Reply to Thread
Results 1 to 5 of 5

Placing the avg. of all range, in every row.

  1. #1
    Forum Contributor
    Join Date
    06-24-2004
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    112

    Placing the avg. of all range, in every row.

    Hello friends, hope all is well!

    please help me; I want to place the average of all the rows, in a column, where every field shows that total average in each row.3
    the attachment should clarify what is needed.

    thank you very much in advance!
    Attached Files Attached Files

  2. #2
    Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    276

    Re: Placing the avg. of all range, in every row.

    Hello,
    in Cell G4 use "=AVERAGE($C$4:$C$12)" and copy +paste to all cells till G13
    Regards,
    Thangavel D

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    BE
    MS-Off Ver
    PC: 97 / 2016 (PQ/PP)
    Posts
    5,792

    Cool Re: Placing the avg. of all range, in every row.

    Is that what you want?
    Attached Files Attached Files
    sandy (NO CAPS)
    Excel can do everything but still doesn't read user's wishful thinking
    The ready made solution will not teach anyone anything

    A logical description of the problem is the basis of dialogue and a rapid solution. Nobody sits in your head to understand your way of thinking
    Note: English is not my native language
    Keep It Sophisticatedly Simple

  4. #4
    Forum Contributor
    Join Date
    06-24-2004
    MS-Off Ver
    Excel 2013 Pro Plus
    Posts
    112

    Re: Placing the avg. of all range, in every row.

    thanks to you all! Sandy how did you do it? awesome

  5. #5
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    BE
    MS-Off Ver
    PC: 97 / 2016 (PQ/PP)
    Posts
    5,792

    Re: Placing the avg. of all range, in every row.

    In DataModel I added Calculated Column: AVG.Total with = AVERAGE([amount]) then PivotTable from DataModel. That's all

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1