worksheet function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On sheet 1 Ihave a list of numbers in column c.

On sheet 2 in column a will be numbers that correspond to sheet 1 column c.
Then sheet 2 column D will have a number hard keyed.

I need a formula on sheet 1 column I that finds the corresponding number on
Sheet 2 and adds up the numbers in column D.

sheet 1 Column c row 1 has 40
Sheet 1 Column c row 20 has 15

Sheet 2 Column a row 1 has 40 and column D has 10
Sheet 2 Column a row 2 has 15 and column D has 3
Sheet 2 Column a row 3 has 40 and Column D has 5

On sheet 1 Column I row 1 should read 15
On sheet 1 Column I row 20 should read 3
 
tiq wrote...
....
I need a formula on sheet 1 column I that finds the corresponding number on
Sheet 2 and adds up the numbers in column D.

sheet 1 Column c row 1 has 40
Sheet 1 Column c row 20 has 15

Sheet 2 Column a row 1 has 40 and column D has 10
Sheet 2 Column a row 2 has 15 and column D has 3
Sheet 2 Column a row 3 has 40 and Column D has 5

On sheet 1 Column I row 1 should read 15
On sheet 1 Column I row 20 should read 3
Click to expand...

Sheet1!I1:
=SUMIF(Sheet2!$A$1:$A$1000,C1,Sheet2!$D$1:$D$1000)

Fill Sheet1!I1 down as far as needed.
 

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

Match and delete rows on two different sheets from reference numbers 4
What type of "lookup" 3
Refernce 2 sheets & same columns & rows 8
Figuring out a lengthy formula. Probably quite simple... 3
matching and entering data 3
use month in cell date to sum all relevant cells 2
SUMPRODUCT has mismatched range sizes error when sheet opened inGoogle Excel. 1
Dependent drop down dynamic range formula, off sheet. 7

Back
Top