View Single Post
  #4   Report Post  
Amada Amada is offline
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by joeu2004[_2_] View Post
"Amada" wrote:
In on cell I have following formula =COUNTIF($N8:$EP8, "V")

[....]
It should counts only numbers with suffix "V"


Ostensibly:

=COUNTIF($N8:$EP8, "*V")

Caveat: That counts anything ending in "V" (as well as "V" along), not just
__numbers__ followed by "V". Okay?
Sorry - but it doesn't work (Excel 2007)