ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Summation Formula Question (Code Inside) (https://www.excelbanter.com/excel-programming/362474-summation-formula-question-code-inside.html)

[email protected]

Summation Formula Question (Code Inside)
 
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.


[email protected]

Summation Formula Question (Code Inside)
 
Anyone?



All times are GMT +1. The time now is 06:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com