|
|
#1
02-11-2012, 12:37 PM
|
|||
|
|||
sum across columns until "0"
Hi,
I'm tyring to find a way to sum a series of cells in a single row until a cell is reached who's value = 0. Example: Row1 cells (columns A thru D then E contains "0") A=1; B=3; C=7; D=9. Then a "0" is detected in cell Column E of row1 so only values A,B,C,D are summed equaling 20. There are multiple rows (35 altogether) and the "0" can show up in any column A thru U or not at all. thank you. Sunnyside 
|
| Thread Tools | |
| Display Modes | |
|
|
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 Vista 
Office 2007
Threaded Mode