Hi all
I try combine AVERAGE(IF(AND..., But it doesn't work, any recommendation?
I only have 1 column in A, for example
A1: A10 will be #s from 1 to 10, And criteria B1=2, C1=8
I want to take average of all #s less than 8
{=AVERAGE(IF(A1:A10<=C1),A1:A10)} <<<< this WORKS
But when I want to take the average of all #s from 2-8
{=AVERAGE(IF(AND(A1:A10>=B1),(A1:A10<=C1)),A1:A10)} <<< Does NOT WORK
any help would be appreciated
I try combine AVERAGE(IF(AND..., But it doesn't work, any recommendation?
I only have 1 column in A, for example
A1: A10 will be #s from 1 to 10, And criteria B1=2, C1=8
I want to take average of all #s less than 8
{=AVERAGE(IF(A1:A10<=C1),A1:A10)} <<<< this WORKS
But when I want to take the average of all #s from 2-8
{=AVERAGE(IF(AND(A1:A10>=B1),(A1:A10<=C1)),A1:A10)} <<< Does NOT WORK
any help would be appreciated