For what purpose?
It is definitely possible to use a function against multiple sheets:
=SUM(Sheet1!A:A, Sheet2!A:A)

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"broogle" wrote in message
oups.com...
Is there anyway to do the groping by column only ? Say, I want to gtoup
sheet1.column A and sheet2.column A. Thanks