sumifs problem

[Korimint]

So I am trying to add numbers between 2 dates. I have named different ranges as in:

Total sales = ToSa2011
tax = Tax 2011n
Date range = DATEN2011

So when I add this formula:

=SUMIFS(ToSa2011,DATEN2011,">="&$D$3,DATEN2011,"<="&$F$3)

it works, but when I do this formula:

=SUMIFS(Tax2011n,DATEN2011,">="&$D$3,DATEN2011,"<="&$F$3)

It doesn't. The only thing I am changing is the criteria range, any ideas why I get a #value! error?

 

[Korimint]

I am using excel 2010, on Windows 7 also.

 

[Aladin Akyurek]

I am using excel 2010, on Windows 7 also.

What are the range references of Tax2011n and DATEN2011? They are probably unequally sized...

 

[Korimint]

What are the range references of Tax2011n and DATEN2011? They are probably unequally sized...

Thanks Aladin, I checked that but really didn't understand which ranges needed to match. I changed the ranges and it works now. Plus I undersatnd what ranges I need to have match now also. Thanks again!