Just coerce from logical (TRUE/FALSE) to numeric (1/0)
=AVERAGE(range*1)
array entered (Ctrl-Shift-Enter)

Jerry

ckdkvk wrote:

I used a logic test to determine some levels from raw scores. For EG

120 =5, 119-110 = 4, etc. I now want to dtermine an average score of

several of the the results from the logic tests but it doesnt seem to
work. (AVG does not recognise cells with logic tests) Can anyone help,
please?