Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel summing problem

  • 19-03-2010 11:23am
    #1
    hamsterboy
    Registered Users, Registered Users 2 Posts: 1,536 ✭✭✭


    Hi All
    I have a problem with Excel 2007.
    I have a range of numbers, which are the results of linking to another worksheet.
    I am trying to sum these numbers, but the usual "=SUM(Q6:Q124)" is just returning a big fat zero.
    Any thoughts?

    Cheers

    HB


Comments

  • #2
    Shane O' Malley
    Registered Users, Registered Users 2 Posts: 1,375 ✭✭✭Shane O' Malley


    Any chances the numbers sum to a figure less than .5 and that the answer cell is set to round to the nearest whole number?


  • #3
    homer911
    Registered Users, Registered Users 2 Posts: 5,150 ✭✭✭homer911


    Are you sure you are referencing financial values? They may be text values being displayed as numbers.

    Alternatively one of the values being summed may be #NA or #DIV/0

    You will need to review your data being summed for errors or invalid data


  • #4
    phog
    Registered Users, Registered Users 2 Posts: 24,974 ✭✭✭✭phog


    Try typing in some of the values and see do they total - if they do it's either the reference or the data is seen as text rather than numbers.


  • #5
    KAGY
    Registered Users, Registered Users 2 Posts: 1,093 ✭✭✭KAGY


    It could be that automatic calculation is turned off, in 2003 it's in options>> Calculations.
    Try pressing f9 to manually recalculate and see if that's the problem.
    Normally if there is a N/A or Div0 in part of the range the sum will show the same error.

    And check that you have the right range selected, double click the cell and check that the box is around the correct cells.


Advertisement