View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
colofnature[_89_] colofnature[_89_] is offline
external usenet poster
 
Posts: 1
Default countif problem when using range name


Change the formula to

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



Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=56252