Thanks that worked! but just to clarify, the cell address has to be without quotes.
=SUMIF(A:A; C1; B:B).
before i even posted here i had tried using the cell address, but i put it between quotes which i know realize meant that Excel was looking for the text value C1 as a criteria instead of the cell address. duh...