If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
=Sumif Problem
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. |
#2
|
|||
|
|||
=Sumif Problem
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))) -- Regards Frank Kabel Frankfurt, Germany Fred wrote: 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Passport Logout Problem | Chen qiang | New Users | 0 | May 4th, 2004 09:26 AM |
Help Microsoft? WORD11.ADM File Problem Line 818? | Dwight Hutchinson | New Users | 2 | May 3rd, 2004 08:25 PM |
Word 2000 footnote problem: footnotes consistently too high (again) | Lori | Formatting Long Documents | 2 | May 1st, 2004 07:15 PM |
problem opening .csv file | Karen | Setting up and Configuration | 0 | September 19th, 2003 02:23 AM |
problem printing dashed lines in graph | Tushar Mehta | Charts and Charting | 0 | September 15th, 2003 10:42 PM |