+ Reply to Thread
Results 1 to 3 of 3

average formula not correct

  1. 03-02-2017, 04:46 PM #1
    [email protected]
    rob@dmsdealer.com is offline
    Registered User
    Join Date
    06-08-2012
    Location
    Naples, FL
    MS-Off Ver
    Excel 2003
    Posts
    17

    average formula not correct

    See attachment please. Help is much appreciated.
    Rob
    Attached Files Attached Files
    Last edited by [email protected]; 03-05-2017 at 10:49 AM. Reason: add attachment
    Reply With QuoteRegister To Reply
  2. 03-03-2017, 07:16 AM #2
    Special-K
    Special-K is offline
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,065

    Re: average formula not correct

    54 views and this is the only reply suggests people are having trouble visualing this.

    Attach a sample spreadsheet with expected results, remove any sensitive data. Use the Go Advanced option at the bottom of the page then scroll down to Manage Attachments as the "paperclip" method does not work on this forum.
    Last edited by Special-K; 03-03-2017 at 08:57 AM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
    Reply With QuoteRegister To Reply
  3. 03-03-2017, 03:09 PM #3
    [email protected]
    rob@dmsdealer.com is offline
    Registered User
    Join Date
    06-08-2012
    Location
    Naples, FL
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: average formula not correct

    Thank you Special K for your input. I hope the attachment is available to whom needs to view it.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula for Predictions League - 3 points correct score or 1 point correct result
    By daveyboy1681 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-17-2016, 04:09 PM
  2. INDIRECT(MATCH...) Formula pulling into correct place but not correct value
    By carrach in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 11-25-2014, 08:14 AM
  3. [SOLVED] Correct syntax for function to find average based on background color of cells in range
    By moosetales in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-21-2014, 12:24 AM
  4. [SOLVED] The formula is correct but one cell does not return correct value
    By [email protected] in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-09-2013, 03:08 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. Who do I average in a filter that currently uses a formula for calculating average based..
    By epiphany33 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-22-2013, 12:22 PM
  7. Correct Use of Average when using sumproduct?
    By cmf0106 in forum Excel General
    Replies: 2
    Last Post: 11-21-2009, 04:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1