Thread: [Solved] sum across columns until "0"
View Single Post
 
Old 02-12-2012, 08:31 AM
sunnyside sunnyside is offline Windows Vista Office 2007
Novice
 
Join Date: Feb 2012
Posts: 9
sunnyside is on a distinguished road
Default RE:Left to right sum to first cell=0

Hi Pecoflyer,
This was very close:
=SUM(a2:u2)-SUM(OFFSET(A2,,,,MATCH(0,A2:U2,0))).

But it adds cells together to the first cell="0" from Right-to-Left + Left-to-Right.
I was looking for only the Right-to-Left if you can modify.

thank you again for your diligence.

sunny
Reply With Quote