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