SUMIFS - Using cell reference in the criteria_range.

[aog]

Hello.
So, I am working on a small project for my self and I met a problem.
My formula looks like this:
=SUMIFS(C18:C35; B18:B35; ">=03.01.2011"; B18:B35; "<=05.01.2011")

The dates marked in red and blue is my problem. I want to use a cell, and not have to put in the dates manualy. The dates are in cell D16 and E16

What I want is some thing like this:
=SUMIFS(C18:C35; B18:B35; >=D16; B18:B35; <=E16)
But that wont work.

Can some one help me with this one?

 

[Oaktree]

Welcome to the board!

Use

">="&D16

instead of

>=D16

 

[aog]

Thank you!

It was that easy.. Almost feel emberest