=SUMIF(A1:A20,D5,B1:B20)

You don't need the = or the quotes when using a cell reference.

"Mon Wolff" wrote:

Please could someone tell me if it is possible to have the criteria point to
another cell, so you can the criteria wihtout having to rewrite the formula.
I've tried:

=SUMIF(A1:A20,"=D5",B1:B20)

but this brings a value of zero.

Thank you.

Monica