Thread: [Solved] sum across columns until "0"
View Single Post
 
Old 02-12-2012, 10:59 AM
sunnyside sunnyside is offline Windows Vista Office 2007
Novice
 
Join Date: Feb 2012
Posts: 9
sunnyside is on a distinguished road
Default Additional detail on Left-to-Right sum until zero cell

Hi Pecoflyer,

Here's the string to assist. Sorry I didn't provide this detail earlier:

Assume a single row with columns A1 thru U1.

10, 12, 1, 2, 0, 3, 6, 7, 18, 20, 0, 3, 4, 30, 10, 12, 11, 0, 2, 1, 7

A1 = 10 and U1 = 7.

The formular should work Left-to-Right starting with U1 and, in this case the answer would be 7+1+2 = 10.

Regards.
Reply With Quote