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
[email protected]


"steve alcock" <steve [email protected]> wrote in message
news:[email protected]...
>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