Help On Excel - Programming - Nairaland
Nairaland Forum › Science/Technology › Programming › Help On Excel (819 Views)
| Help On Excel by MightySparrow(op): 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(op): 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. |
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
Oracle Tutorial • How To Optimize Blog To Appear On Search Engine • How To Build A Daily Deals Website In A Small Investment Of $149?