sum across columns until "0"

		Microsoft Office Forums > Microsoft Excel > Excel
sum across columns until "0"

FAQ

Mark Forums Read

Thread Tools

Display Modes

02-12-2012, 02:13 AM

Pecoflyer

Windows XP sum across columns until "0"

Office 2003

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,943

Pecoflyer has a reputation beyond repute

Perhaps

Code:

=SUM(a2:u2)-SUM(OFFSET(A2,,,,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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:55 PM.