You can achieve this by using MOD()...

In A1: =SUMPRODUCT(--(MOD(COLUMN(A8:IV8),4)=2),A8:IV8)
In B1: =SUMPRODUCT(--(MOD(COLUMN(A8:IV8),4)=2),--(A8:IV8<""))

Does that help?
--
Regards,
Dave


"Hugh Murfitt" wrote:

I have a spreadsheet which will build up over the next few weeks with each
weeks results adding four columns of data to the sheet €“ sheet1.

I then want to perform analysis on the data in another sheet €“ sheet2

eg. In cell A1: SUM(sheet1!B8,sheet1!F8,sheet1!J8,etc,
and in cell B1: COUNT(sheet1!B8,sheet1!F8,sheet1!J8,etc,
etc

Is there a way of calculating €œevery 4th cell€� in a row. There will be
several weeks of data and doing this long-hand (as above) is time consuming.
I dont yet know how many weeks of data there will be and I dont want to
have to add extra terms to the COUNT, SUM, etc each time I add a new week.

Perhaps there is a way of creating a Range of this nature€¦? I clutch at
straws. Can you help?