Hi
what I want to know is soem exact details (cell references). e.g.
- in which sells is the month name (in row 1, etc.)
- which cells do you want to sum

As said: just post some example data as plain text

"cookie" wrote:

I have a spreadsheet set up which feed in monthly figures eg in jan figures
are put in under the jan heading. in feb figures are put in under the feb
heading etc. at the bottom of the sheet is a total for all months, but need
to write a formula to add only two columns if the month is feb or 10 columns
if month is october.

"Frank Kabel" wrote:

Hi
you may provide some more details about your data structure. e.g. post some
example rows of data as plain text

"cookie" wrote:

need to add figures to give total figures to period end each month and do not
want to keep doing it. the figures are fed into the spreadsheet
automatically on a monthly vasis