Try...
=sumif(O18:O500,B21,Q18:Q500)

--

XL2003
Regards

William



"steve alcock" <steve wrote in message
...
I want to sumif the value of a cell and not have to use the actual value in
quotes, is this possible ????

thanks

steve alcock