problem with SUMMEWENN

  • Thread starter Thread starter snowflow
  • Start date Start date
S

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
 
Try...

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

Hope this helps!
 
try changing your equation to
=SUMMEWENN(Alle!AI3:AI484;">="&A3;Alle!AI3:AI484)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difficult Countif with multiple sheets 2
How To Link To An External Dynamic Named Range 1
Any Way Around 7-Nested Function Limit? 9
Formulas Instead of Advanced Filter 5
Formula with MID() not working 7
Help with Formula for................. 5
Help with IF Functions 4
apply arithmetic functions on special multiple cells 5

Back
Top