+ Reply to Thread
Results 1 to 6 of 6

Sum and divide

  1. #1
    Registered User
    Join Date
    05-28-2014
    MS-Off Ver
    2013
    Posts
    10

    Sum and divide

    Got another fun one for you guys.

    I am looking for a formula to sum up all numbers and divide by how many numbers exist. Some columns may have 4 numbers in it so I want it to sum the 4 numbers and divide by 4. Same goes for if they only have 1 number to divide by 1 in the column or 10 numbers to divide by 10.
    Last edited by ArmyGuy45; 06-19-2014 at 01:15 PM.
    US Army 2005 - 2014

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,598

    Re: Sum and divide

    Give some examples of how your data is laid out, or attach a sample workbook. Do you mean that you have multiple values within one cell, and that you want the average of that cell? If so, how is the data separated - with a comma, or comma-space, or something else?

    Pete

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Sum and divide

    hi there. wont AVERAGE do the job for you? if numbers are in column A, then:
    =AVERAGE(A:A)

    or if you dont want to average 0s, then:
    =AVERAGEIF(A:A,">0")

    ps: it would be good to put your Excel version in your profile so we can provide suitable formulas available to you

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  4. #4
    Registered User
    Join Date
    05-28-2014
    MS-Off Ver
    2013
    Posts
    10

    Re: Sum and divide

    Average worked. Thank you.

  5. #5
    Registered User
    Join Date
    05-28-2014
    MS-Off Ver
    2013
    Posts
    10

    Re: Sum and divide

    Well, sorta solved. I get the DIV/0 error so I inserted the "<0" and now I get VALUE error.

  6. #6
    Registered User
    Join Date
    05-28-2014
    MS-Off Ver
    2013
    Posts
    10

    Re: Sum and divide

    =IF(SUM(E38:E49)=0,"NA",AVERAGE(E38:E49))

    Got it to work with this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Divide by zero
    By mmccra2858 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-26-2012, 08:37 AM
  2. divide by zero
    By DIM TIM in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2007, 04:08 AM
  3. [SOLVED] get #DIV/0!:divide by zero
    By chiuinggum in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-08-2006, 04:55 AM
  4. [SOLVED] divide by 0
    By sony654 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2005, 04:08 AM
  5. Divide by Zero
    By rocky in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-22-2005, 08:06 AM

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