External reference as a condition

[Ingeniero1]

I searched this forum and found how to use =SUMPRODUCT instead o
COUNTIF to include more than one condition - great!

Now, instead of entering the condition directly into the function, suc
as "Green", I would like to 'point' to a cell that contains the wor
"Green". Example, instead of [=SUMPRODUCT((B31:B431="Green"..., writ
[=SUMPRODUCT((B31:B431="$X$24"... where X24 contains "Green"

Also, instead of entering a number, such as >15, point to a cell tha
contains the number 15. Example, instead o
[=SUMPRODUCT((B31:B431>15..., write [=SUMPRODUCT((B31:B431>$Y$25...
where Y25 contains 15.

Is this possible? How?

Thanks for your time!

Ale

 

[JulieD]

Hi

in formulas when you use "" it means anything contained between them is a
literal text string ... so by using "$X$24" you're looking for the words
$X$24
so all you need to do is remove the ""

the > one will work as you're written it below
=SUMPRODUCT((B31:B431>$Y$25) ....

Cheers
JulieD

 

[RagDyer]

You just did it, *except*, take the quotes away from the "$X$24" !
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


I searched this forum and found how to use =SUMPRODUCT instead of
COUNTIF to include more than one condition - great!

Now, instead of entering the condition directly into the function, such
as "Green", I would like to 'point' to a cell that contains the word
"Green". Example, instead of [=SUMPRODUCT((B31:B431="Green"..., write
[=SUMPRODUCT((B31:B431="$X$24"... where X24 contains "Green"

Also, instead of entering a number, such as >15, point to a cell that
contains the number 15. Example, instead of
[=SUMPRODUCT((B31:B431>15..., write [=SUMPRODUCT((B31:B431>$Y$25...
where Y25 contains 15.

Is this possible? How?

Thanks for your time!

Alex