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

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