Thread: countif problem when using range name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Andrew Taylor Andrew Taylor is offline
external usenet poster
  
Posts: 225
Default countif problem when using range name
=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

Reply With QuoteReply With Quote