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

    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

    Appreciate the help? CLICK *

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    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)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  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
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,750

    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