Using criteria in an Array

  • Thread starter Thread starter andym
  • Start date Start date
A

andym

I wish to be able to reference a "<",">",>=" etc. type of criteria in an
array, but am an unable to manage it.

eg ... {=SUM((Range="ValueOne")*(Range="<=10"))}

I have no problem achieveing a set value .. ie:
{=SUM((Range="ValueOne")*(Range=2))}

Could anybody please help me with a solution to this??

many thanks...

andym
 
Sorry, just to add to this ... I wish to reference the "<=10" etc from
another cell ...

eg ... {=SUM((Range="ValueOne")*(Range=A1))}, where A1 is <=10 for
example..

thanks...

**********************************************************************
I wish to be able to reference a "<",">",>=" etc. type of criteria in an
array, but am an unable to manage it.

eg ... {=SUM((Range="ValueOne")*(Range="<=10"))}

I have no problem achieveing a set value .. ie:
{=SUM((Range="ValueOne")*(Range=2))}

Could anybody please help me with a solution to this??

many thanks...

andym
 
andym wrote
I wish to be able to reference a "<",">",>=" etc. type of criteria in an
array, but am an unable to manage it.

eg ... {=SUM((Range="ValueOne")*(Range="<=10"))}

I have no problem achieveing a set value .. ie:
{=SUM((Range="ValueOne")*(Range=2))}

Could anybody please help me with a solution to this??

many thanks...

andym
Click to expand...


Andy M,

I think it is ...

{=SUM((Range="ValueOne")*(Range<=10))}

Good luck.

Kevin
 
andym

=sumproduct((range="value one")*(range<=A1))

*not* an array formula... so just ENTER...

Cheers
Juan
 
Back
Top