Q1: This will give you the sum of A2, E2, I2 etc up to IA2:

=SUMPRODUCT(--(MOD((COLUMN(A1:IA1)-1),4)=0),A2:IA2)

Q2: You can test for integer like this:

=IF(A1=INT(A1),"Integer","Not integer")

Hope this helps.

Pete

On Nov 24, 7:05*pm, Neil Pearce wrote:
Dear all,

Qu. 1: I have a worksheet with over 200 columns. *The columns' headings
repeat every four columns, e.g. Heading A, Heading B, Heading C, Heading D,
Heading A, Heading B...

I wish to add a total column at the end for each heading, =A2+E2+I2+M2+.... *
This is clealy a laborious and tedius method. *Is there an easy way of
calculating this?

Qu. 2: the IS forumla can be used to check cells for their specifics, e.g..
ISNUMBER(). *Further is there a means of distinguishing if the cell is an
integer, e.g. ISINTEGER()? *If not any ideas how I would be able to do this?

Thanking-you.

Cheers,

Neil