 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2008formula
SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26) It will not allow and giving error of #VALUE Please help! =SUM(T1:T6,T15,T24:T26) On Jan 24, 3:04 pm, jennifer.chaf...@power.alstom.com wrote: > SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26) > > It will not allow and giving error of #VALUE > > Please help! > =SUM(T1:T6,T15,T24:T26) > [quoted text clipped - 7 lines] > > - Show quoted text - Thanks, Jason. I am helping a co-worker and do not have the file. He stated he tried that, but didn't work. He doesn't have time to check at this time. I'll let you know how it goes. I am new at Google Groups, but was told so many good things that I had to try. Thanks for the help! Try it like this: =SUM(L21:N21,J35,R17:R22) > SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26) > > It will not allow and giving error of #VALUE > > Please help! =SUM(T1:T6,T15,T24:T26) Gord Dibben MS Excel MVP >SUM of multiple cells (Ex. =SUM(T1:T6)+(T15)+(T24:T26) > >It will not allow and giving error of #VALUE > >Please help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.