hello there everyone, could someone tell me the formula to sum up numbers with two combination of letters, Example:
A
1 5hr
2 8ps
3 2ws
4 3hr
5 2ps
total 8hr
total 11ps
total 2ws
hello there everyone, could someone tell me the formula to sum up numbers with two combination of letters, Example:
A
1 5hr
2 8ps
3 2ws
4 3hr
5 2ps
total 8hr
total 11ps
total 2ws
It would be best to separate the numbers from the text then perform the sums.
Assuming the values are in cells A1:A5, in:
B1: =MID(A1,1,LEN(A1)-2)+0
C1: =RIGHT(A1,2)
Create a list of the unique 2-letter text strings then use SUMIF on the range B1:C5
=SUMIF($C$1:$C$5,"hr",$B$1:$B$5)
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks