Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,151,215 members, 7,811,591 topics. Date: Sunday, 28 April 2024 at 03:12 PM

Help On Excel - Programming - Nairaland

Nairaland Forum / Science/Technology / Programming / Help On Excel (726 Views)

Datagridview Export To Excel Vb.net / How To Send Data To Excel In Vb 2008 Without Crystal Report? / Command Button On Excel (2) (3) (4)

(1) (Reply) (Go Down)

Help On Excel by MightySparrow: 1:24pm On Dec 03, 2014
Could someone tell me why =sum() didn't sum up in my excel. the same command performed well earlier in the program but refused to perform st some point.
I know something went wrong could someone tell me possible causes?
Re: Help On Excel by losprince(m): 2:11pm On Dec 03, 2014
show the equation
Re: Help On Excel by MightySparrow: 3:23pm On Dec 03, 2014
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! 3340 2588500 563 500
#REF! 500 387.5 552 500
#REF! 500 387.5 53 500
#REF! 500 387.5 552 715
#REF! 500 387.5 5000 500
TOTAL #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!



Sorry, the lines could not be copied. I want to add vertically. I used = sum(number1:number2). I didn't get the answer.
Re: Help On Excel by losprince(m): 10:49am On Dec 04, 2014
MightySparrow:
#REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! 3340 2588500 563 500
#REF! 500 387.5 552 500
#REF! 500 387.5 53 500
#REF! 500 387.5 552 715
#REF! 500 387.5 5000 500
TOTAL #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF!



Sorry, the lines could not be copied. I want to add vertically. I used = sum(number1:number2). I didn't get the answer.
to acess a cell use the alphabet and number associated with it eg sày you want to access the first cell yu use a1 not number one hope this helps
Re: Help On Excel by HeroKing: 11:14am On Feb 23, 2015
Check the referenced cell for each of the cells with #REF!.

The message is simply indicating that there are non-numeric data items in the cells, thus Excel could not add it up. Ensure that you format the cells to read the content as numbers instead of text; this should resolve the problem.

Hope this helps.

(1) (Reply)

How To Make My Postbackurl Asp.net Work With Conditions / Microsoft BASIC Programming Tutorials / Hotel Management Software Development

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 9
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.