Results 1 to 3 of 3

problem with inaccurate result with AVERAGE

Threaded View

  1. #1
    Registered User
    Join Date
    06-03-2008
    Posts
    2

    problem with inaccurate result with AVERAGE

    Hi

    I am using Excel 2003 for a montly cost analysis and having trouble with AVERAGE.

    Simple explanation.

    column E contains hours
    column F contains dollars
    column G calculates dollars per hour

    cell G1 calculates the average of G3:Gxxx

    cell Exx calculates the sum of column E
    cell Fxx calculates the sum of column F

    cell H10 divides Fxx by Exx and should be equal to G1 But it is NOT. In fact it is over 5% different, even with a sheet with only 9 rows in it.

    What am I doing wrong here?

    Excel 2003
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compute and store average scores
    By jgombola in forum Excel General
    Replies: 1
    Last Post: 11-11-2007, 12:31 AM
  2. Resolved >>> Find the top result for each category
    By roger_bl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2007, 06:07 AM
  3. Average problem
    By tuph in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-01-2007, 05:48 AM
  4. Spell number
    By nowfal in forum Excel General
    Replies: 4
    Last Post: 08-20-2007, 04:21 PM
  5. How do I omit zeros from average?
    By Ohucan2 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-05-2007, 10:46 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