# Need Help With Array Formula

#### hotchix

##### New Member
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!

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

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

which just needs enter.

#### hotchix

##### New Member
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.

Replies
1
Views
149
Replies
4
Views
172
Replies
0
Views
105
Replies
6
Views
259
Replies
3
Views
168

1,196,010
Messages
6,012,840
Members
441,733
Latest member
MartijnB

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back