Microsoft Office Forums - View Single Post - [Solved] sum across columns until "0"

Thread: [Solved] sum across columns until "0"

View Single Post

02-11-2012, 12:45 PM

Pecoflyer

Windows XP Pecoflyer uses Office 2003

Office 2003

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,920

Pecoflyer has a reputation beyond repute

Hi Perhaps something like

Code:

=sum(offset(A1,,,,match(0,a1:a100,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