Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average If Adejecent Cells Greater Than Zero | Excel Worksheet Functions | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
requires that merged cells must be identically sized? | Excel Discussion (Misc queries) | |||
How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions |