Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 16 Feb 2014 23:56:19 +0100Find line and count numbershttps://ask.libreoffice.org/en/question/29944/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
Sun, 16 Feb 2014 19:47:02 +0100https://ask.libreoffice.org/en/question/29944/find-line-and-count-numbers/Answer by oweng for <p>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</p>
<p>a _ b _ c d e f g _ h</p>
<p>1 _22 _ 12 11 22 33 11 22 _ 0</p>
<p>2 _ 22 _ 11 22 11 21 11 12 _ 1</p>
<p>3_ 12 _ 12 21 11 11 21 11 _ 2</p>
https://ask.libreoffice.org/en/question/29944/find-line-and-count-numbers/?answer=29955#post-id-29955It 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.Sun, 16 Feb 2014 23:56:19 +0100https://ask.libreoffice.org/en/question/29944/find-line-and-count-numbers/?answer=29955#post-id-29955