sumif function on multiple sheets

  • Thread starter Thread starter Guest
  • Start date Start date
=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 said:
i want to use sumif function on multiple sheet with critria that rang cell
Click to expand...
#""
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shorten multiple sumifs 2
Vlookup or SumIF to sum multiple cells matching the same criteria 0
Refer a column in the 'sumif' function 2
sumif 2
SUMIF with multiple sheets 5
SUMIF with the criteria range 4
sumifs question 2
SUMIF in VBA 1

Back
Top