| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summation Formula Question (Code Inside)
Anyone?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMMATION combined with PV formula | Excel Worksheet Functions | |||
| Summation question | Excel Worksheet Functions | |||
| Summation Formula Needed | Excel Worksheet Functions | |||
| VBA code to perform summation and product summation | Excel Programming | |||
| VBA : VBA code for summation formula | Excel Programming | |||
Linear Mode
