Sum a Row Starting with First non Zero Value

R

rca

I am trying to determine how to write a formula to sum the part of a ro
starting with the cell to the right of the last non zero value, whil
ignoring all numbers to the left of the last zero. Hope that make
sense.

Maybe an example will make it clear as mud. I've attached
spreadsheet with the total column computed like I would like th
formula to calculate.

Basically I want the Total formula to only sum starting with the firs
cell to the right of the last non-zero cell
 
A

Aladin Akyurek

In N2 enter:

=SUM(INDEX(B2:M2,MATCH(9.99999999999999E+307,IF((ERROR.TYPE(1/B2:M2)=2)*ISNU
MBER(B2:M2),1))):M2)

Commit this with control+shift+enter instead of just enter then copy down.
 
R

rca

Could you explain why that works? I'd like to have a bette
understanding of the solution.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Last non-zero 5
Zero and Null Sum Function 2
NumberFormat for small non-zero numbers? 2
Finding NEXT to last, non zero numeric value in a row 3
Counting Zeros in a row until encounter first non-zero value 9
Excel: Last non zero value in a row 4
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Cell Value must be zero 4

Top