=Sumif Problem

  • Thread starter Thread starter Fred
  • Start date Start date
F

Fred

I want to do a formula like this. I hope it makes sence.

=sumif("Range of Worksheets"!"Range of rows inside
worksheets","Key Word","Range of Worksheets"!"Range of
rows inside worksheets")

Any help would be great. Thanks.
 
Hi
try the following:
1. Create a list with your worksheet names and assign a name to this
range (e.g. 'wslist')
2. Now use the following formula
=SUMPRODUCT(SUMIF(INDIRECT("'" & wslist & "'!A1:A100),"key
word",INDIRECT("'" & wslist & "'!B1:B100)))
 
Back
Top