You are better off Grouping your 25 Worksheets and entering the SUMPRODUCT
Function once with NO sheet references, then use =SUM(Sheet1:sheet25!A1) to
get you grand total. Where A1 on each of the 25 sheets contains your
SUMPRODUCT Function.


--
Regards
Dave Hawley
www.ozgrid.com

"Radhakant Panigrahi" wrote in message
...
Hi,

I am using the below sumproduct formula
=sumproduct((sheet1!A1:A50000="Mark")*(sheet1!A1:A 50000="Automatic"))

I have to make the formula for almost 20-25 sheets. so i have to put the
formula in 25 cells to know the result of 25 sheets.

Is there any sumproduct formaula to take the data from all sheet at one go
and give me the result in one cell

regards,
rkp