Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumif function on multiple sheets
i want to use sumif function on multiple sheet with critria that rang cell #""
|
#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 #"" |
Reply |
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 |