View Single Post
  #1   Report Post  
Amada Amada is offline
Junior Member
 
Posts: 3
Default COUNTIF - help please

In on cell I have following formula =COUNTIF($N8:$EP8, "V")
It counts cells which contain "V"
I have to modify this formula - and need your help.
In my cells ($N8:$EP8) I can have for example 1V or 2V or 6V
How to count "Vs" , for example, one cell "2V" other cell "5V" - resoult = 7
It should counts only numbers with suffix "V"
THanks in Advance