Average of logic cells
 

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?


--
ckdkvk
------------------------------------------------------------------------
ckdkvk's Profile: http://www.excelforum.com/member.php...o&userid=29245
View this thread: http://www.excelforum.com/showthread...hreadid=489704

Average of logic cells
 

hi, ckdkvk !

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)...

I'm not sure to got your point, but assuming that 120 = 5 <::: 80 = 1
for a range from 'A1:A10', try with:
=sumproduct(match(a1:a10,{0;80;90;100;110;120})-1)/count(a1:a10)

hth,
hector.

Average of logic cells
 

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?