Hello Roshlin,

If you need your non-adjacent areas counted together, select them all,
goto Insert, Name, Define... and define a name for this non-adjacent
range - let us say D.

Then select an adjacent output area of two colums and with as many
rows as you need and array-enter
=lfreq(D)
[enter with CTRL + SHIFT + ENTER, not only with ENTER]

The expected output should appear now.

Regards,
Bernd