=Sumif Problem

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.
 
F

Frank Kabel

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)))
 

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

Use TODAY() function as the criteria in a SUMIF formula 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
sumif issues 1
Combine Sumifs with Subtotal 0
Multiple Columns in Sum Range using SUMIFS 1
MS Word normal.dot cannot be fixed 'text box' appears each time 4
SUMIF over multiple spreadsheets 4
Standar deviation across sheets help 0

Top