What formulae to derive?

J

Jeffrey

I want to calculate the average of scores achieved by a guy.

for e.g:
A B C D E
1 2 3 4
smith 98 65 98 96
donald 97 94 92 93
alex 91 90 89 97
ronald 91 94 95 97
jose 94 95 92 90
brad 94 91 95 94
donald 98 65 98 96
brad 97 94 92 93
jose 91 90 89 97
alex 91 94 95 97
davis 94 95 92 90
smith 94 91 95 94

average of Scores achieved by alex(if his name is there in column A)

lets say i want the answer in B17.......

What formulae should I derive to calculate this?
 
D

Don Guillett

This is an ARRAY formula that must be entered using ctrl+shift+enter instead
of just enter
=AVERAGE(IF(A2:A13="alex",B2:E13))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top