Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Find line and count numbers

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