Following the syntax of the SUMIFS formula --> Can "criteria_range1" be the same as "criteria_range2" ?

It didn't work for me and I got the result as 0.