Used vba WorkheetFunction.SumIfs method in Excel 2016. It worked fine. However, it only gave 0 values in Excel 2019 but no error message. Why?

Question

I composed a code in vba using the Worksheet.Sumifs method. It worked fine in Excel 2016. When I tried to run the code again in a colleagues laptop with Excel 2019, the output had only zero values. Initially, it felt strange...when I ran the code in another PC with Excel 2016, it worked fine. Normally, I assumed that a older version may not be compatible with a newer version. Here, however, it was the opposite.

I am looking for inputs if anybody else encountered such a situation. Also, wish somebody else would try it out and offer their feedback.

Thanks.