How can I use the Excel function SUMIF in a table considering the data are vertically displayed and the criteria are not in the same rows as the items that must be summed? There is a 1-row shift.

Answer 1

Suppose your data are in B3:B22, your criterion is “>”, and you comparison data are in C4:C23.

enter the formula =sumif(B3:B22,”>5”,C4:C25)