| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct of multiple sheets
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct Multiple W/Sheets | Excel Discussion (Misc queries) | |||
| SUMPRODUCT FOR MULTIPLE SHEETS | Excel Discussion (Misc queries) | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| Sumproduct on multiple sheets...please help??? | Excel Worksheet Functions | |||
| sumproduct from multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
