# Get instant live expert help on sumif using dates

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

Hello, hope all is well. Can you please help me use sumif formula using dates. I want to sum values if the date is before 31/12/2018 but it's not working although i used =SUMIF(\$I\$152:\$I\$238,"<r152",\$J\$152:\$J\$238). I part includes dates, R is the 31/12/2018 and J part is the values to be summed.
Solved by V. E. in 30 mins
I want to use SUMIF function where condition would be *July* as i'm working with the dates. However, dates are being transferred into number values
Solved by V. J. in 14 mins
Could you help me to understand when sumif & countif are using?
Solved by G. C. in 25 mins
I need help with an excel problem using SUMIF
Solved by M. W. in 17 mins
I am using SUMIF nested formula, and I need a way to dynamically reference a column on another sheet using a cell
Solved by Z. Y. in 25 mins