[FONT="]I've been working on a formula that counts how many sites fall within the radius of another site.[/FONT]
[FONT="]This is the formula I've used. =COUNTIFS('0301 Master'!H:H,"<"&$D2,'0301 Master'!H:H,">"&$F2,'0301 Master'!I:I,">"&$E2,'0301 Master'!I:I,"<"&$G2)[/FONT]
[FONT="]Is there a way to list the names of the sites that are counted?[/FONT]
[FONT="]This is the formula I've used. =COUNTIFS('0301 Master'!H:H,"<"&$D2,'0301 Master'!H:H,">"&$F2,'0301 Master'!I:I,">"&$E2,'0301 Master'!I:I,"<"&$G2)[/FONT]
[FONT="]Is there a way to list the names of the sites that are counted?[/FONT]