On Tue, 24 Jan 2012 15:18:39 +0000, Amada wrote:

Stan Brown;1214641 Wrote:
On Mon, 23 Jan 2012 19:59:28 +0000, Amada wrote:-

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-

=sumproduct( 0+right($N8:$EP8,1)="V") )

Sorry but it has Error in Value

I don't know what you mean by "error in value", but I can assure you
that I tried it myself before posting and it was just fine. Try
copy-pasting instead of retyping.

Please remember to trim quotes when posting a follow-up.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...