C
cgreen07
I have ranges made up of non-adjacent cells from one worksheet and I
get a #VALUE! error when I try to do any conditional count or sum
calculation with an array formula on either or both of them. Each
range is a selection of 32 non-adjacent cells from a single column.
The cells contain array formulas that return percentages.
Example of range values
I8: 5.9%
I11: 12.1%
I14: 22.3%
I17: 0.0%
I was able to get values returned from simple functions like Max and
Min but the following example gives me the #VALUE! error:
{=SUM(IF((Rng>0),1,0))}
=COUNTIF(Rng,"<.0125")
Any wisdom would be appreciated!! Thanks
get a #VALUE! error when I try to do any conditional count or sum
calculation with an array formula on either or both of them. Each
range is a selection of 32 non-adjacent cells from a single column.
The cells contain array formulas that return percentages.
Example of range values
I8: 5.9%
I11: 12.1%
I14: 22.3%
I17: 0.0%
I was able to get values returned from simple functions like Max and
Min but the following example gives me the #VALUE! error:
{=SUM(IF((Rng>0),1,0))}
=COUNTIF(Rng,"<.0125")
Any wisdom would be appreciated!! Thanks