SUMIF(O18:O500,"=b21"Q18:Q5) i want to do this not "=001690"
 

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

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