Hey all, I thank all of you who try and answer my question.

So anyway, I have a formula in a "tracking" sheet that counts how many of a specific word shows up in a "record" sheet. The formula is basically this:

=COUNTIF(tracking!$D$4:$D$69,B8)

The count is basically specific names of vendors for my company. It looks up the name of what its suppose to find (B8) and looks through D4 through D69 to find that specific name.

I have another column H4 through H69 within the tracking sheet. These are the number of days the specific vendor took to finish. I am trying figure out how to average the days where it matches to the vendor name. So if I was looking for a Vendor named "Gary" and that showed up in D6, the formula would then go to H6 and grab the number and plop it into an AVERAGE formula.

I'm not sure how to do this, any help would be great.

Thanks!