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 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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