Thanking-you all for the earlier repsonses.

Is it possible to apply a SUMIF formula across several worksheets within a
workbook too? The below appeared not to work

=SUMIF(Start:End!$A$1:$A$10,Summary!$A$1:$A$10,Sta rt:End!$B$1:$B$10)

Any ideas would be much appreciated.


Kind regards,

Neil


"Dave Peterson" wrote:

Not that I know.

In fact, depending on the version of excel that you're using, you may not be
able to do it in a single formula. The length of the formula is limited to 1024
characters (when measured in R1C1 reference style) in xl2003 and below.

If you meant worksheets within the same workbook, you could use a "sandwich"
technique:

Put a sheet to the left of the 100 sheets. Name it Start.

Put a sheet to the right of the 100 sheets. Name it End.

Then make sure that there are no other sheets between those Start and End
sheets.

Then put this in a cell on a different sheet (outside that sandwich, too!):

=sum(start:finish!A1)



Neil Pearce wrote:

Dear all,

Is there a quick formula I can use to add all A1 cells across 100 different
workbooks?

Kind regards,

Neil

--

Dave Peterson