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. |
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