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