+ Reply to Thread
Results 1 to 3 of 3

Formula to calculate average in a column

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Formula to calculate average in a column

    Hello:

    Please refer to attached sheet.
    We get checks from Client and i add them up in excel sheet as is shown in column B,C,D,E,etc
    Sum of checks is in Row 4.
    I need a formula for Row 3, to calculate the average per check for that particular deposits.
    Example : Column B , Total of all checks was $4865.80 consisting of 75 checks so averge would be
    $4865.80/75 = $64.88 This would need to be in B3

    Similarly C3 = 7145.01/136 = $52.54
    D3
    E3, etc.....

    Please let me know if you have any questions.

    Thank you in advanve for your help.

    RM
    Attached Files Attached Files
    Last edited by rizmomin; 11-27-2010 at 06:41 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula to calculate average in a column

    Hi,

    =AVERAGE(B5:B404)

    Rgds
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Re: Formula to calculate average in a column

    Hi:

    Thank u so much...that was easy fix...

    This will be great help for me...

    RM

+ 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