|
|
|
|
#1
02-12-2012, 09:16 AM
|
||||
|
||||
Sorry, I wrongly assumed there would only be one 0 in the row Is this better ? Code:
=SUM(OFFSET(U2,,,,-MATCH(0,a2:u2,0)))
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
#2
02-12-2012, 10:59 AM
|
|||
|
|||
|
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.
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to "Fast Forward" or "Jump into" a slide while testing
|
George Daly | PowerPoint | 1 | 10-14-2011 06:49 AM |
| How to edit the "Format" and the "show level" of an EXISTING table of content? | Jamal NUMAN | Word | 2 | 08-14-2011 10:46 AM |
|
"Table of content" based on "Normal Style" behavior!!!!
|
Jamal NUMAN | Word | 4 | 07-08-2011 04:12 AM |
|
How to choose a "List" for certain "Heading" from "Modify" tool?
|
Jamal NUMAN | Word | 2 | 07-03-2011 03:11 AM |
| "Microsoft Excel Application" missing in the "Component Services" on win08 | sword.fish | Excel | 0 | 02-26-2010 02:09 PM |
Windows XP 
Office 2003
Hybrid Mode