Results 1 to 20 of 20

Need help with average formula

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    30

    Need help with average formula

    I need some help formatting an "average" formula for excel 2010 please

    I have 3 rows (B8 to M8, B9 to M9 and B10 to M10) for the months of the year that I need to get an average for. There are 36 cells that may or may not have dollar amounts in them and I need to get an average for all those cells that have dollar amounts in them. So if 25 cells have figures in them I need the average for those 25 cells not all 36. Cells may have 20 of them with dollar amounts or 32 etc. so the average needs to be calculated without the empty cells. How do it accomplish this?
    Thanks in advance for any help.
    Gene
    Last edited by genestoy; 11-16-2016 at 10:36 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index, Match formula returns #NA error if result is from an average formula.
    By billrogers184 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-28-2016, 11:43 AM
  2. [SOLVED] Using the Average formula in VBA gives different results to worksheet Average formula
    By Sc0ut in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-06-2016, 06:02 AM
  3. [SOLVED] Average formula that shows 0 but does not count in average
    By Lewster in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 11-11-2015, 04:49 PM
  4. [SOLVED] Rank numbers by average with doing average formula
    By makinmomb in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-26-2014, 11:58 PM
  5. [SOLVED] need formula to average cells but if one cell has N/A then dont average and input N/A
    By CityInspector in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-08-2013, 04:16 PM
  6. Replies: 0
    Last Post: 01-22-2013, 12:22 PM
  7. [SOLVED] how does one convert text to a formula "average(A:A)" to =average(
    By phshirk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-13-2005, 09: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