Ask Your Question
0

how to test value is in range

asked 2016-10-28 23:16:06 +0100

mgh1302 gravatar image

Please help , this must be so easy but Ive read so much ive confused myself I have a column of figures in E3 to E20 I want to count how many fall between certain ranges

ie 0 – 19 20- 39 40 – 49 50 – 100

what is the formula in libre office 3 . its so easy in excel so must be easy on here as well ?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-10-28 23:32:56 +0100

m.a.riosv gravatar image

I think FREQUENCY() function is a good choice.

https://help.libreoffice.org/Calc/Arr...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-28 23:16:06 +0100

Seen: 278 times

Last updated: Oct 28 '16