problem with SUMMEWENN

[snowflow]

Hello,

I hope you will understand me, because of my bad english.
I have following problem.
I want to do the following function:

=SUMMEWENN(Alle!AI3:AI484;">=20";Alle!AI3:AI484)

The result is correct. But now I want to make several arithmetics lik
that:

=SUMMEWENN(Alle!AI3:AI484;">=A3";Alle!AI3:AI484)

but the result is always 0, allthough there is also 20 in A3.

I hope you can help me.

Many thanks

Floria

 

[Domenic]

Try...

=SUMMEWENN(Alle!AI3:AI484;">="&A3;Alle!AI3:AI484)

Hope this helps!

 

[bj]

try changing your equation to
=SUMMEWENN(Alle!AI3:AI484;">="&A3;Alle!AI3:AI484)