Yes, the second formula I gave you only sums every 5th column.

In article ,
Sam wrote:

great! that worked as far as getting the SUMPRODUCT formula to bring back a
value. however, i'm still having trouble getting it to only sum specific
cells in that row. it's not returning an error, but it is adding everything
in that row. is there a way to select specific cells to sum together?