Hi!
One way:
Entered as an array using the key combo of CTRL,SHIFT,ENTER:
=SUM(OFFSET(D2,,MATCH(1,(ISNUMBER(E2:IV2))*(E2:IV2 0),0),,4))
Adjust for the end of the range as needed.
Biff
wrote in message
ups.com...
Hello,
Don't know if this easy or not.
I am trying to write a formula that finds the 1st value in a column
that is 0 and then sum that value and the next 4 columns across.
For example my formula is in D2 and I want to find the 1st value to the
right of the formula that is 1 and add up that value and the next 4
values to the right of this
Any help would be appreciated!
Thanks
Pete
|