The easy one first:

=a1=int(a1)
will return true if A1 is an integer.
(Do you have to check for numeric, too?)

=and(isnumber(a1),a1=int(a1))

The other one:
=sumif($a$1:$Gr$1,"Heading A",$a2:$gr2)



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

--

Dave Peterson