Find line and count numbers

[Nemonom]

hi i got a problem whit finding a specific line in a column “h” must be more than 0 and after i vant to count in that specific row numbers in columns “c” to “g” no other numbers, tried countifs find but get only err. is this possible

a _ b _ c d e f g _ h

1 _22 _ 12 11 22 33 11 22 _ 0

2 _ 22 _ 11 22 11 21 11 12 _ 1

3_ 12 _ 12 21 11 11 21 11 _ 2

[oweng]

It is not clear why “finding a specific line in a column H” is important, however it is easy enough to conditionally sum a range. Place this formula in cell I1 and copy down:

=IF(H1>0,SUM(C1:G1),"N/A")

Adjust the “N/A” entry to suit i.e., make it zero or a null string if desired.