Hi,

I am using the below sumproduct formula,

=Sumproduct((Sheet1!A1:A50000="Mark")*(Sheet1!A1:A 50000="Automatic"))

I have 25 sheets and i have put the formula in 25 different cells to know
the result.

Is there any sumproduct formula or any other formula that can calculate the
data from 25 sheets and give me in single cell

regards,
rkp