+ Reply to Thread
Results 1 to 5 of 5

Calculate average percentage for specific selected cells

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    34

    Calculate average percentage for specific selected cells

    Hello everyone
    Please help

    I need to calcualte a percentage average for specefic selected cells which formula should I use?

    Will really appreciate your help

    Thanks

    Megan

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    6,149

    Re: Calculate average percentage for specific selected cells

    =AVERAGE(cell1,cell2,cell3,so on and so forth)

  3. #3
    Registered User
    Join Date
    10-23-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: Calculate average percentage for specific selected cells

    Quote Originally Posted by BadlySpelledBuoy View Post
    =AVERAGE(cell1,cell2,cell3,so on and so forth)
    The problem is I have a spreadsheet with questions the questions are answered by a 0 or 1 or n/a if u type n/a then it must exlude that from the percentage I managed to get a formula with average if but I need the formula to work out if i select a1 skip a2 then calculate a3 and a4

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    6,149

    Re: Calculate average percentage for specific selected cells

    Perhaps some sample data with expected results would be helpful...

  5. #5
    Registered User
    Join Date
    10-23-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: Calculate average percentage for specific selected cells

    I will upload the document tomorrow internet connection is giving problems

+ 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. Calculate Average in VBA for specific cells
    By kapil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-09-2010, 12:24 PM
  2. [SOLVED] calculate average in percentage coloumn with #DIV/! (ignore error
    By neelsels SA in forum Excel General
    Replies: 2
    Last Post: 09-06-2005, 10:05 AM
  3. [SOLVED] calculate monthly average percentage of change
    By vikgarden in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-15-2005, 03:06 PM
  4. [SOLVED] Need formula to calculate average monthly percentage of change...
    By vikgarden in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2005, 02:06 PM
  5. How do I create a formula to calculate the average percentage rat
    By LD in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-13-2005, 03:06 PM

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