Sunday, October 7, 2012

yogi_Compute Cumulative Scores In Range B2:2 Based On Scores In Range B1:1

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #794  Oct 07, 2012

user jocks24 said: (!category-topic/docs/spreadsheets/Q-Rvpbo4ePE)
accumulative scores

In a spreadsheet, how do i split a cell in half, ie, / but half the cell with a number in the top half, and an accumulative number in the bottom half.  Like cell 1 is 3, cell 2 on the same row is 2/5 which is a score plus the previous score added in bottom half, cell 3 is 1/6, cell 4 is 2/8, cell 5 is 1/9, cell 6 is 3/12.. Does this make sense to anyone?  I am on a laptop with Windows 7 and using Google drive spreadsheet. Thanks for any help.
Thick silversurfer, lol
 following is a single cell arrayformula solution to the problem