Ask Your Question
0

how to know how many entries are there are in a column with a range [closed]

asked 2014-04-24 07:11:03 +0100

akash gravatar image

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

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-21 07:18:24.954758

1 Answer

Sort by » oldest newest most voted
0

answered 2014-04-24 13:52:17 +0100

JohnSUN gravatar image

Do you mean something like this? Chart by rngs

Formulas in this simple demo was:

=RANDBETWEEN(100;270)
=COUNTIF(Src;D2)
=SUMPRODUCT(Src>D2;Src<=D3)
edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-04-24 07:11:03 +0100

Seen: 101 times

Last updated: Apr 24 '14