+ 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
    118

    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
    Valued Forum Contributor than_gold's Avatar
    Join Date
    10-17-2017
    Location
    Coimbatore India
    MS-Off Ver
    Office 365
    Posts
    360

    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
    Old Country
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    8,284

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

    Is that what you want?
    Attached Files Attached Files
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    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

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

    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
    Old Country
    MS-Off Ver
    PC: 5F / 61 / 7E0 (PQ/PP)
    Posts
    8,284

    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