I am trying to sort through a file and select only the 25th line of a
secondary worksheet titled "raw data". The basic formula I was using is
below:

=SUM((E4:E23)*(MOD(ROW(E4:E23)-ROW(E4);5)=0))

My formula looks like this:

=SUM(('Raw Data'!B36:B16500)*(MOD(ROW('Raw Data'!B36:B16500)-ROW('Raw
Data'!B36);25)=0))

It won't work, and I'm wondering what I'm doing wrong.

Thanks.