Hi,

I want to use sumif in the following way :

SUMIF(purchases!O18:purchases!O500,"=b21",purchase s!
Q18:purchases!Q500)

and not :

SUMIF(purchases!O18:purchases!O500,"=01960",purcha ses!
Q18:purchases!Q500)

in otherwords I want to use the value of the cell b21 to
look up and not the typed in value ( 01960 ) can this be
done ?

thanks

steve