ST Alpha - "=SUMPRODUCT(--(MOD(ROW(C17:C31),5)=3),C17:C31)" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 170

In response to "Excel help question" by Gwaahjo

=SUMPRODUCT(--(MOD(ROW(C17:C31),5)=3),C17:C31)

Posted by oblique, new and shiny (aka kkuphal) Oct 15 '08, 11:03

or something like that

Responses:

*swoon* -- nm - ReluctantCynic Oct 15, 11:19
That is a cool solution. -- nm - psilotum Oct 15, 11:10
This link should help make sense of the forumla -- (link) - oblique, new and shiny Oct 15, 11:07

Post a message top