Sumproduct of multiple sheets

  • Thread starter Radhakant Panigrahi
  • Start date
R

Radhakant Panigrahi

Hi,

I am using the below sumproduct formula,

=Sumproduct((Sheet1!A1:A50000="Mark")*(Sheet1!A1:A50000="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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top