Why it happens!!!???
would you please give me any way how can i add these value in Excel?
i have to add all value for example: =sum(ak2:ak1885) and when i hit enter then it shows #REF!, why?????

Question

Why it happens!!!???
would you please give me any way how can i add these value in Excel?
i have to add all value for example: =sum(ak2:ak1885) and when i hit enter then it shows #REF!, why?????

Answer

Because the cell is too small. You have to widen it!

Or you have a non-numerical cell in the column.

Answer

I use ms office 2007 and it works just fine. I try typing "=SUM(AF2:AF1250)" at cell AG1250.

Answers · 4

Still haven’t found your answers?

Don’t miss out on the opportunity to learn a language from the comfort of your own home. Browse our selection of experienced language tutors and enroll in your first lesson now!