Please answer me.

Closed
bablukmr2012
Posts
1
Registration date
Tuesday July 30, 2013
Status
Member
Last seen
July 30, 2013
- Jul 30, 2013 at 03:46 PM
russp5
Posts
4
Registration date
Friday August 2, 2013
Status
Member
Last seen
August 2, 2013
- Aug 2, 2013 at 01:27 PM
ram-5,raja-2,rani-6,ram-2( i want to know the excel formula for count th total no. of ram )

3 replies

TrowaD
Posts
2880
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 2, 2022
509
Aug 1, 2013 at 11:30 AM
=5+2 :)

sorry couldn't help myself
0
Blocked Profile
Aug 2, 2013 at 10:16 AM
Use the Sumifs function in Excel to get the total of a specific text in a cell.
0
russp5
Posts
4
Registration date
Friday August 2, 2013
Status
Member
Last seen
August 2, 2013
1
Aug 2, 2013 at 01:27 PM
If the cell contains the string as specified, you have 2 options:
1. Use the text to columns to split the text across columns by comma and dash. This will isolate the texts preceding the dash and isolate "ram".
2. Create a user defined function in VBA that splits the texts and uses the Instr command to count the instances of the text to be found e.g. "ram"
0