Sumif issue with date

Originally Posted by XOR LX

"I would not recommend to use thw whole column range as it will slow down calculation but if you insist you can use C:C and D:D."

Generally, yes, though as I understand it, one of the advantages of the SUMIF(S), COUNTIF(S), etc. family of functions is that they calculate the UsedRange only; hence no loss in performance is typically associated with referencing entire columns.

Regards

That worked great! Thanks for the timely reply