=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
#""