Matrix, Latitude, Longitude, Radius, Count

[exc4libur]

Hi fellas

How are u?

Let's cut to the chase. I am doing a map research to find the count of stores that are close to each other, inside a 3 km radius. I have a solution but it's long and takes a lot of space. So if anyone can come up with a different more convenient solution, I would appreciate it
Maybe say, using sumproduct? (i know its volatile, but its ok).

I have attached an example workbook.

Best rgds,
exc4.

 

[Hui]

C17: =SUMPRODUCT(--((6372.7976*ACOS(COS(RADIANS(90-$A$5:$A$10))*COS(RADIANS(90-A17))+SIN(RADIANS(90-$A$5:$A$10))*SIN(RADIANS(90-A17))*COS(RADIANS($B$5:$B$10-B17))))<3))

Copy C17 down

see attached file:

 

[exc4libur]

Thank you very much Hui