Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-12-2017, 11:41 PM
Cyberseeker Cyberseeker is offline Sum within a single Cell? Windows 10 Sum within a single Cell? Office 2010 32bit
Advanced Beginner
Sum within a single Cell?
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default Sum within a single Cell?

This may sound a little odd, but I would like a single cell to display two figures in the following format: + 19 + 1 Both plus (+) signs need to be displayed.



Then, in an adjacent cell I would like to sum the first cell and divide it thus: =B69/4 The answer in this hypothetical example should be "5", but no plus sign should appear in this case.

My efforts today give me a result of, "#value" Can I get it to do what I want?

Thanks for any help.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum within a single Cell? Combining several cells data into one single cell H28Sailor Excel 6 01-09-2017 06:00 AM
Sum within a single Cell? Sum values within a single cell shabbaranks Excel 17 05-13-2014 06:47 PM
Sum within a single Cell? How to count multiple values in a single cell, except zero? iuliandonici Excel 1 04-13-2011 09:45 PM
Sum within a single Cell? Sum & difference between multiple values in a single cell iuliandonici Excel 4 04-13-2011 09:27 PM
Sum within a single Cell? How can I write the following (whole) formula in a single cell? Learner7 Excel 1 07-19-2010 10:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft