Sum of a formula across more than one worksheet

[Mully1986]

Hi

I have formulas set up across a few worksheets and basically they show a calculation for how much money is spent each month.

I need to compile this in a central summary sheet.

I have used the formula =SUMPRODUCT('January Summary'!E2) which returns the value of the formula that I have on the "January" woksheet but I also need to know the sum of the formula in the same cell but in the "February" Worksheet and have this added to the January number so the summary sheet show the total value of January and February combined.

Help please!! ive been trying to work this out for ages.

[NBVC]

Try something like:

=SUM('January:February'!E2)

If you are adding sheets on the fly, then create empty BookEnd sheets, called Start and Finish, respectively, then use:

=SUM('Start:Finish'!E2)

Now you can add or remove sheets between without any fuss.

[Fotis1991]

Hi

..Maybe =SUM(January Summary:February Summary!e2)