• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

#N/A when entering a simple SUM formula

H

Hayley

Member
This is weird. I have a column of numbers and I did =sum(d2:d980) and the result is #N/A.


When I highlight the entire column it only gives me a count in the lower right corner...it doesn't show average or sum also like it usually does.


I highlighted the column and made sure they were all formatted to be numbers.


What the heck is going on???
 
Even though the cells are formatted as number, doesn't necessarily mean that everything in there is a number. Sounds like you've got a N/A error being generated somewhere in the range. I'd suggest selecting the column, and then use Ctrl+g, Special Cells, Contants -> and check Text and Errors to see if there's anything funny going on.
 
You must log in or register to reply here.
Back
Top