Need Help With Array Formula

[hotchix]

I'm going crazy trying to figure out this formula. I setting up a timesheet and I have a list of 200 project codes in cells z7:z207. In cells a7:a21 is a place that I enter the project codes that I worked on this month. In cells b7:b21 is where I enter the number of hours that I worked on the project codes in cells a7:a21.

I want to write a formula that compares the project codes in cells a7:a21 with the project codes in cells z7:z207. For those project codes that are contained in both ranges, I want to sum cells b7:b21.

If anyone could help with this formual I would greatly appreciate it.

Thank You in Advance!

 

[Aladin Akyurek]

=SUMPRODUCT(--ISNUMBER(MATCH($A$7:$A$21,$Z$7:$Z$207,0)),$B$7:$B$21)

which just needs enter.

 

[hotchix]

Thank you very much for the quick response. I applied your formula and it worked. I'm new to this forum and I think it provides a great service. Thanks again for taking the time to help me.