Ask Your Question
0

Find line and count numbers [closed]

asked 2014-02-16 19:47:02 +0200

Nemonom gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 10:56:51.274936

1 Answer

Sort by » oldest newest most voted
1

answered 2014-02-16 23:56:19 +0200

oweng gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-02-16 19:47:02 +0200

Seen: 91 times

Last updated: Feb 16 '14