HOW MANY "/" IN THIS CELL A1 = "RG/351/87/11/3"
 

hi,
i want to calculate the following;
CELL A1 HAS A VALUE = RG/351/87/11/3
1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL
2- HOW MANY "3" (THREE) IN THIS CELL.
ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC
WORD/NUMERIC/SPECIAL CHARACTER IN A CELL.
THANKS FOR YOUR COOPERATION.
I HOPE I WILL GET IT SOON.

SAQIB YAQUB

HOW MANY "/" IN THIS CELL A1 = "RG/351/87/11/3"
 

=LEN(A1)-LEN(SUBSTITUTE(A1,A2,""))

Put this in b1 and the character you want to count in A2

"- - - - -" wrote:

hi,
i want to calculate the following;
CELL A1 HAS A VALUE = RG/351/87/11/3
1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL
2- HOW MANY "3" (THREE) IN THIS CELL.
ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC
WORD/NUMERIC/SPECIAL CHARACTER IN A CELL.
THANKS FOR YOUR COOPERATION.
I HOPE I WILL GET IT SOON.

SAQIB YAQUB

HOW MANY "/" IN THIS CELL RANGE A1:A5
 

Dear Mike,
thanks for reply.
I have one query more. if i have a range then how i can calculate;
CELL A1 RG/351/87/11/1
CELL A2 RG/351/87/11/2
CELL A3 RG/351/87/11/3
CELL A4 RG/351/87/11/4
CELL A5 RG/351/87/11/5

THANKS FOR IN ADVANCE.
TAKE CARE
SAQIB YAQUB


"Mike" wrote:

=LEN(A1)-LEN(SUBSTITUTE(A1,A2,""))

Put this in b1 and the character you want to count in A2

"- - - - -" wrote:

hi,
i want to calculate the following;
CELL A1 HAS A VALUE = RG/351/87/11/3
1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL
2- HOW MANY "3" (THREE) IN THIS CELL.
ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC
WORD/NUMERIC/SPECIAL CHARACTER IN A CELL.
THANKS FOR YOUR COOPERATION.
I HOPE I WILL GET IT SOON.

SAQIB YAQUB

HOW MANY "/" IN THIS CELL RANGE A1:A5
 

=SUMPRODUCT(LEN(C1:C5)-LEN(SUBSTITUTE(C1:C5,"/","")))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"- - - - -" wrote in message
...
Dear Mike,
thanks for reply.
I have one query more. if i have a range then how i can calculate;
CELL A1 RG/351/87/11/1
CELL A2 RG/351/87/11/2
CELL A3 RG/351/87/11/3
CELL A4 RG/351/87/11/4
CELL A5 RG/351/87/11/5

THANKS FOR IN ADVANCE.
TAKE CARE
SAQIB YAQUB


"Mike" wrote:

=LEN(A1)-LEN(SUBSTITUTE(A1,A2,""))

Put this in b1 and the character you want to count in A2

"- - - - -" wrote:

hi,
i want to calculate the following;
CELL A1 HAS A VALUE = RG/351/87/11/3
1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL
2- HOW MANY "3" (THREE) IN THIS CELL.
ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC
WORD/NUMERIC/SPECIAL CHARACTER IN A CELL.
THANKS FOR YOUR COOPERATION.
I HOPE I WILL GET IT SOON.

SAQIB YAQUB

HOW MANY "/" IN THIS CELL RANGE A1:A5
 

=SUMPRODUCT(LEN(A1:A1000)-LEN(SUBSTITUTE(A1:A1000,C1,"")))

Checks the range A1 _ A1000 for the character in C1

"- - - - -" wrote:

Dear Mike,
thanks for reply.
I have one query more. if i have a range then how i can calculate;
CELL A1 RG/351/87/11/1
CELL A2 RG/351/87/11/2
CELL A3 RG/351/87/11/3
CELL A4 RG/351/87/11/4
CELL A5 RG/351/87/11/5

THANKS FOR IN ADVANCE.
TAKE CARE
SAQIB YAQUB


"Mike" wrote:

=LEN(A1)-LEN(SUBSTITUTE(A1,A2,""))

Put this in b1 and the character you want to count in A2

"- - - - -" wrote:

hi,
i want to calculate the following;
CELL A1 HAS A VALUE = RG/351/87/11/3
1- HOW MANY "/" (FORWARD SLASH) IN THIS CELL
2- HOW MANY "3" (THREE) IN THIS CELL.
ACTUALLY THIS QUESTION IS ABOUT TO COUNT/SUM ANY SPECIFIC
WORD/NUMERIC/SPECIAL CHARACTER IN A CELL.
THANKS FOR YOUR COOPERATION.
I HOPE I WILL GET IT SOON.

SAQIB YAQUB