1. On Worksheet1, Rows Column A, Rows 1-2000, listing of all possible locations. On Sheet2, Column A, Rows 1 through 350, a listing of all contract numbers that had activity during a given month. On Sheet2, Column B, Rows 1 through 350, a listing of all locations used by the respective contracts during the month.

On Sheet1, column Z, rows 1-2000 I would like a formula that would return the data from the corresponding cell in Sheet2, where the names of the locations are the same, and the contract number is equal to "123456". I would prefer a function that is not a SUMPRODUCT, as, with 2000 rows, the recalc can take a little time.

Any ideas?

2. Originally Posted by jlkirk
On Worksheet1, Rows Column A, Rows 1-2000, listing of all possible locations. On Sheet2, Column A, Rows 1 through 350, a listing of all contract numbers that had activity during a given month. On Sheet2, Column B, Rows 1 through 350, a listing of all locations used by the respective contracts during the month.

On Sheet1, column Z, rows 1-2000 I would like a formula that would return the data from the corresponding cell in Sheet2, where the names of the locations are the same, and the contract number is equal to "123456". I would prefer a function that is not a SUMPRODUCT, as, with 2000 rows, the recalc can take a little time.

Any ideas?

Hi jlkirk,

SUMIF can only handle one variable, but you've got two. If you're using Excel 2007, you could use the SUMIFS function.

3. Originally Posted by macropod
Hi jlkirk,

SUMIF can only handle one variable, but you've got two. If you're using Excel 2007, you could use the SUMIFS function.
Thanks. in fact I am using 07. Any clues?

4. Originally Posted by jlkirk
Thanks. in fact I am using 07. Any clues?
Hi jlkirk,

Have you checked out the SUMIFS function? The Excel '07 help file describes its use.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•