Hi,
something cool I learned:
You can sum every n row with this formula:
=sumproduct((mod(row(H00002:H130764),125)=0)*(H00002:H130764))
Change the red sections to the range you need and to the exact n number of rows you need.
Hi,
something cool I learned:
You can sum every n row with this formula:
=sumproduct((mod(row(H00002:H130764),125)=0)*(H00002:H130764))
Change the red sections to the range you need and to the exact n number of rows you need.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks