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

in other words, concatenate the operator and the cell value.

But actually, the = is not needed, it is assumed, so you could just use

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

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Mon Wolff" wrote in message
...
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