| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif function on multiple sheets
=SUMPRODUCT(SUMIF(INDIRECT("'"&C1:C3&"'!a2:a20"),
"*TOTAL*",(INDIRECT("'"&C1:C3&"'!b2:b20")))) as an example, where C1:C3 is a range housing the relevant sheetnames in separate cells. -- HTH Bob Phillips (remove nothere from email address if mailing direct) "muhammed arshad" <muhammed wrote in message ... i want to use sumif function on multiple sheet with critria that rang cell #"" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sumif over multiple sheets | Excel Discussion (Misc queries) | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| sumif function with multiple sheets | Excel Discussion (Misc queries) | |||
| sumif across multiple sheets | Excel Worksheet Functions | |||
| SUMIF on multiple sheets | Excel Worksheet Functions | |||
![Bob Phillips[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
