Matching, sum and return a value

[jvwild]

Hello!

I have just started a new job and trying to get a handle on some new data and techniques, and I could use some help!

I need to be able to match a project number in one excel sheet, to another, and return a sum of 2 cells relating to the project number to the original sheet. Basically, adding up 2 revenues from one sheet (projects are actually on multiple worksheets), match, and returning the value to another worksheet that already is listing the project numbers. Can anyone suggest how to do this in the most efficient manner? Thank you!!

Worksheet 1
Project # Total Revenue
1
2
3
...
498 $$$
499
...
600

Worksheet 2
Project # Revenue 1 Revenue 2
498 100 300
499
500
501
...

-J

 

[CharlesChuckieCharles]

=INDEX(Sheet2!$C$1:$E$23,(MATCH($C4,Sheet2!$C$1:$C$23,0)),2)+INDEX(Sheet2!$C$1:$E$23,(MATCH($C4,Sheet2!$C$1:$C$23,0)),3)

where $C4 is your project number

Sheet2!$C$1:$C$23 your list of projects


$C$1:$E$23 is the array on sheet2 of Project Number Rev1 rev2 ( not in red column numbers 2 and 3 )


if there is more than one entry per project

try

=SUMIF(Sheet2!$C$1:$C$23,Sheet1!C4,Sheet2!$D$1:$D$23)+SUMIF(Sheet2!$C$1:$C$23,Sheet1!C4,Sheet2!$E$1:$E$23)

where

Sheet1!C4 = project number
Sheet2!$C$1:$C$23 = project number list

Sheet2!$D$1:$D$23 = rev 1
Sheet2!$E$1:$E$23 = rev 2

 

[jvwild]

Thank you. THANK YOU!! That saved me a lot of hassle! It makes all the sense when I see it now. I need to get a better hold of my excel functioning skills.