Microsoft Office Forums - View Single Post - 5000 rows, want to select and perform addition on ever 48 rows

Thread: 5000 rows, want to select and perform addition on ever 48 rows

View Single Post

Old

06-09-2019, 11:07 PM

Rexmaverick Rexmaverick is offline

Rexmaverick is offline

Rexmaverick uses Windows 10

Windows 10 Rexmaverick uses Office 2016

Rexmaverick uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jun 2019

Posts: 3

Rexmaverick is on a distinguished road

Default

Just found the old one, it is every 15 rows, =IF(MOD(C2,15)=0,E2,0) can drag this down and it does it.

Thanks anyway, always appreciated.

Reply With Quote