Index/Match Formula across 2 worksheets

[Adrian]

New to all this so any help would be really appreciated. (Using Office 2003)

I have 2 worksheets and need a formula (possibly index/match) to add up
total course hours in Worksheet 2 where the Course Number in Column A matches
the course number in column B.

Worksheet 1
Column A Column B
Course Number Course Hours
1 20
1 25
2 30
2 35

Worksheet 2
Column A Column B
Course Number Total Course Hours
1 ?
2 ?


As I say any help would be greatly appreciated.

Many thanks

Adrian

 

[Domenic]

On Sheet2, try...

B2. copied down:

=SUMIF('Sheet1'!$A$2:$A$5,'Sheet2'!A2,'Sheet1'!$B$2:$B$5)

Hope this helps!

 

[Dave]

Hi,
Try this in B1, sheet 2, and copy down:

=SUMPRODUCT(--(Sheet1!$A$1:$A$5=A1)*(Sheet1!$B$1:$B$5))

Regards - Dave.

 

[Adrian]

Domenic - you're a star - worked a treat ))))

 

[Adrian]

Thanks for replying Dave - I had success with Domenics solution but
appreciate your time and knowledge!!!