Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum
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 |