Lookup / countif functions

D

davidbrowne17

ok, here we go.

i have a list of random names in colum A5:A50
and in collum B5:B50 scores

i need a formular that will, for a given NAME , will return the NUMBE
of times that a score of over 100 is achieved. in the tabl
G5:H5.....i'm guessing some kind of conditional LOOKUP & CONTI
functions are needed?

As attached sample sheet.

Any answers apreciated

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54337
 
D

davidbrowne17

thanks rank, but what does the -- signify in the formular?

(e-mail address removed)
 
J

JE McGimpsey

The first of the two - signs in the formula converts the boolean
TRUE/FALSE to -1/0. The second unary minus sign converts -1/0 to 1/0.

This is necessary because SUMPRODUCT() requires numeric arrays, not
boolean.
 

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