ExcelBanter - Sumproduct of multiple sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sumproduct of multiple sheets (https://www.excelbanter.com/excel-discussion-misc-queries/263896-sumproduct-multiple-sheets.html)

Radhakant Panigrahi

Sumproduct of multiple sheets

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

All times are GMT +1. The time now is 12:17 PM.