Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,194,735 members, 7,955,792 topics. Date: Sunday, 22 September 2024 at 03:14 PM |
Nairaland Forum / Science/Technology / Programming / Help On Excel (749 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)
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: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)
Why You Should Write Tests? / Using Blockchain Technology To Boost Cyber Security / Friendzone
(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. 12 |