average product

[blackstar]

Hello here's what i need to do

average the percentage of results in another workbook based on user names

so, bassically get the average of results in colum B of workbook 1 but only if the corresponding cells in colum A in workbook 1 match to cells in colum C in workbook 2.
help pls!

[blackstar]

ok figured it out.

=SUMIF('[Weekly Audit .xls]January'!$E$2:$E$251,$A6,'[Weekly Audit.xls]January'!$V$2:$V$251)/COUNTIF('[Weekly Audit.xls]January'!$E$2:$E$251,$A6)

but i have another problem. if there is no hits on a user name i want a formula incorperated into the above that will i dunno say no data or something like that.. help?