Sum within a single Cell?

jeffreybrown · #1 01-14-2017, 07:09 AM

Try...

Code:

       ----B---- C D E ----F----
  75   +1279 + 1       87 Months
  76   +1290

F75 =(SUM((TRIM(MID(SUBSTITUTE(B75,"+",REPT(" ",255)),1+(ROW($A$1:$A$200)-1)*255,255)) & "0")/10)+(B76+0))/29.5306

IMPORTANT

This is an array formula
Enter the formula >> press F2 then >> CTRL + SHIFT + ENTER
If entered correctly, the formula will be enclosed in {brackets}
Do not enter the {brackets} manually

Custom Format >> F75

Right click cell (or Ctrl + 1)
Format Cells
Number
Custom
Type: 0" Months"

Quote:

Also, I need to fill down the "F" column so that this formula keeps repeating adjacent to its respective cells in "B" column.

If the current values are in B75 and B76 with the result in F75, where are the next values, B77 and B78?

If so, you can just copy F75 and paste into F77.

How far down do you need to copy? How many results did you need?

Cyberseeker · #2 01-14-2017, 10:18 AM

Quote:

Originally Posted by jeffreybrown

If the current values are in B75 and B76 with the result in F75, where are the next values, B77 and B78?

B78 and B79 (B77 is missed out)

Quote:

Originally Posted by jeffreybrown

How far down do you need to copy? How many results did you need?

Its open-ended, however Ill probably stop at 210 results.

Thanks for your good help. I have filled down for 50 results and it works like a charm.

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