SUMIFS error

Disregard this post

If your file isn't too big maybe attach it so we can take a look.

Originally Posted by strud

Unfortunately I cannot, but why did you say disregard it, it was a genuine question as to whether anyone had had the same issue

I made an incorrect suggestion in that post so I removed it but you can't make an empty post so I added the disregard note.

If you are trying to SUM when the date is between 1st and 28th august then you need to make the second >= into a <= like this

=SUMIFS(DE_nQty,DE_Line,'Helper Cells'!B1,DE_Date,">="&DATE(2014,8,1), DE_Date,"<="&DATE(2014,8,28))

Hi,

I suspect Tony had written a comment, posted to the thread and then realised he wanted to change it so went back to edit the comment out and added disregard this. He probably caught the post in the first couple of minutes which is why it isn't annotated with the 'Edit'...comment by the software. I'm sure he was meaning disregard his post not yours.

Why can't you upload the workbook. All we want is a sample with just a few rows that exhibit the problem. Anonymise any data if necessary.

Originally Posted by strud

thanks, i had missed that bit, but the other still remains even when I alter that

How are the ranges defined? Try checking that all named ranges start on the same row

Originally Posted by strud

Not sure why it is different for SUMIF and SUMIFS given that that was the solution.

Was the SUMIFS formula actually giving you an error value rather than an incorrect result?

SUMIFS is different to SUMIF in that regard - if you use mismatched ranges in SUMIFS you get a VALUE# error, in SUMIF if you use mismatched ranges then excel implicitly adjusts the 2nd range (sum range) so that it's the same size/shape as the 1st range, so no error