Assuming your data from A1:A11

=SUM(OFFSET(INDEX(A1:A11,MATCH(TRUE,A1:A11<0,0)), ,,6))

ctrlshiftenter (not just enter)

--------------------
mama no teeth

"Cecilia" wrote:

How do I add the first nonzero values of a row when they appear in various
columns?

I only need to add the first six values that are nonzero but these appear in
various columns throughout my table.