Using INDIRECT with STDEV and IF statements

[tonysandiego]

I’m trying to make INDIRECT work with STDEV and IF.


This works fine:

=AVERAGEIF(INDIRECT($A$23),C29,INDIRECT($B$23))


So does this:

=COUNTIF(INDIRECT($A$23),C29)


And this (without INDIRECT):

{=STDEV.P(IF(OOData!$G$34:$G$5686=$C29,OOData!$CG$34:$CG$5686))}


I’d like to change the above formula to something like:


{=STDEV.P(IF(INDIRECT($A$23),C28,INDIRECT($B$23)))}

But the statement above doesn't work

The contents of A23 is ‘OOData’!$G$34:$G$5686

And B23 is ‘OOData’!$CG$34:$CG$5686

Thanks!

 

[barry houdini]

Don't you need to use the same syntax as the original, i.e.

{=STDEV.P(IF(INDIRECT($A$23)=C28,INDIRECT($B$23)))}