Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenThu, 24 Apr 2014 13:52:17 +0200how to know how many entries are there are in a column with a rangehttps://ask.libreoffice.org/en/question/33097/how-to-know-how-many-entries-are-there-are-in-a-column-with-a-range/i am having a sheet which is having a column of integer data size 500 now i have to draw a frequency graph making a range like entries between 250-260 should count in a single group.Is there any way to do it in libreoffice
Thu, 24 Apr 2014 07:11:03 +0200https://ask.libreoffice.org/en/question/33097/how-to-know-how-many-entries-are-there-are-in-a-column-with-a-range/Answer by JohnSUN for <p>i am having a sheet which is having a column of integer data size 500 now i have to draw a frequency graph making a range like entries between 250-260 should count in a single group.Is there any way to do it in libreoffice </p>
https://ask.libreoffice.org/en/question/33097/how-to-know-how-many-entries-are-there-are-in-a-column-with-a-range/?answer=33107#post-id-33107Do you mean something like this?
![Chart by rngs](/upfiles/13983400054983941.gif)
Formulas in this simple demo was:
=RANDBETWEEN(100;270)
=COUNTIF(Src;D2)
=SUMPRODUCT(Src>D2;Src<=D3)Thu, 24 Apr 2014 13:52:17 +0200https://ask.libreoffice.org/en/question/33097/how-to-know-how-many-entries-are-there-are-in-a-column-with-a-range/?answer=33107#post-id-33107