Hi,

Try something like this:

=SUMPRODUCT(--(MOD(ROW(F14:F100),6)=2),F14:F100)

HTH
Jean-Guy

"Blade370" wrote:

Maybe I wasn't clear enough. I have to add up cells in a column that are 6
cells apart as these cells contain the figures I need to sum. However I do
not want to have to select all of these sells individually. Is there any
function I could use to simplify this? I have seen one that sums figures in a
row which were 10 cells apart i.e. A10, A20, A30 etc using
sumproduct((mod(row(A1:A50),10),0)*A1:A50)). Is there anything like this for
columns? As my info starts at F14 and is in every sixth colum after that.


"pinmaster" wrote:

Hi,

Sounds like you have the weekly totals and the daily totals in the same
column. Why not put the weekly totals in a seperate column and then sum that
column? In any case if you want specific answers then you'll need to provide
more details.

Regards!
Jean-Guy

"Blade370" wrote:

I am working on a spreadsheet that has weekly totals stored on it. I want to
attach a summary page that shows the sum of these totals. Is there any way I
can setup the function to pick up the cells that have the weekly totals
without having to select each cell individually?