sum of every 4th cell in a row.

M

Monique

I am trying to set up a spread sheet where each element in a row has four
different columns of data. At the end of the row I need to do various
calculations based on the sum of each column for each element.

BX5 = C5+G5+K5+O5+etc.
BY5 = D5+I5+L5+P5,+etc

I've seen several similar calculations using data in column, but not in rows
and I have not been able to translate that info into rows.

Monie
 
T

T. Valko

Try this:

=SUMPRODUCT(--(MOD(COLUMN(C5:AA5)-COLUMN(C5),4)=0),C5:AA5)

Adjust for the correct end of the range.
 
T

T. Valko

Try this:

=SUMPRODUCT(--(MOD(COLUMN(C5:AA5)-COLUMN(C5),4)=0),C5:AA5)

Adjust for the correct end of the range.
 
M

Monique

Thanks. I see what I was doing wrong in my translation from rows to columns.
I was not being specific enough about the cells to calculate.
 
M

Monique

Thanks. I see what I was doing wrong in my translation from rows to columns.
I was not being specific enough about the cells to calculate.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum cells based on number of months 6
insert muliple rows, every 4th row 7
Possible sumproduct to find/sum the last entry in each row 2
formula is too long error 3
Is there an Excel Function that can be used in lieu of this formul 5
SUM Every Trird Cell In A Row 3
data from 1 sheet to the next 6
How to sum the last 7 number in a row? 6

Top