 |
 | 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 / New Users / February 2008: in cell references in formula (Excel 2003)
Someone put the following formula into a spreadsheet that I have to maintain: =ABC!H14:ABC!H18+ABC!H24 I understand the use of : to pass a ranged to a function, but this does not make sense to me. It only adds the values from H14, H18, and H24. Is the use of the : here a typo that happens to work, or is there a good useful purpose for it? Thank you. JerryK It doesn't seem like that should be working. I get a #VALUE! when I use it. If it was intended to sum the range plus H24, then: =SUM(ABC!H14:H18)+ABC!H24 If only those three cells were supposed to be added, then: =SUM(ABC!H14,ABC!H18,ABC!H24) or =ABC!H14+ABC!H18+ABC!H24 HTH, Paul > Someone put the following formula into a spreadsheet that I have to > maintain: [quoted text clipped - 7 lines] > Thank you. > JerryK It sums the values from sheet ABC H14:H18(5 cells) + H24 6 cells in all. Easier written as =ABC!H14:H18 + ABC!A8 Gord Dibben MS Excel MVP >Someone put the following formula into a spreadsheet that I have to maintain: >=ABC!H14:ABC!H18+ABC!H24 [quoted text clipped - 5 lines] >Thank you. >JerryK Forgot the SUM function =SUM(ABC!H14:H18) + ABC!A8 Gord >It sums the values from sheet ABC H14:H18(5 cells) + H24 > [quoted text clipped - 13 lines] >>Thank you. >>JerryK If you check your data, you'll see that *only* H14 and H24 are being totaled. You need the Sum() function, as others have brought to your attention.  SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Someone put the following formula into a spreadsheet that I have to maintain: > =ABC!H14:ABC!H18+ABC!H24 [quoted text clipped - 5 lines] > Thank you. > JerryK |
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.