countif problem when using range name

Hello All
I have a number say 6 in cell A3 which is named as 'MP01'; in another
cell i have a formula =countif(D1:D10,">MP01") but this does not work!
However if i have =countif(D1:D10,MP01+2) then this works.
Many thks for your help
Rgds
KZ

Change the formula to

=countif(D1:D10,">"&MP01)



Col

=COUNTIF(D1:D10,">"&MP01)


Kieranz wrote:
> Hello All
> I have a number say 6 in cell A3 which is named as 'MP01'; in another
> cell i have a formula =countif(D1:D10,">MP01") but this does not work!
> However if i have =countif(D1:D10,MP01+2) then this works.
> Many thks for your help
> Rgds
> KZ

Andrew
Many thks
KZ

Andrew Taylor wrote:
> =COUNTIF(D1:D10,">"&MP01)
>
>
> Kieranz wrote:
> > Hello All
> > I have a number say 6 in cell A3 which is named as 'MP01'; in another
> > cell i have a formula =countif(D1:D10,">MP01") but this does not work!
> > However if i have =countif(D1:D10,MP01+2) then this works.
> > Many thks for your help
> > Rgds
> > KZ