Question description:
This user has given permission to use the problem statement for this
blog.
Hi. I'm trying to track my time at work. I have 5 column ranges with a few different text items (administration, management, personal, etc). In separate cells I'd like to add all the times each text item appears and then add them up.
To clarify, I want to check ranges C5:C37, F5:F37, I5:I37, L5:L37, O5:O37 for text "administration" and add them all up in 1 cell.
Solved by V. A. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/08/2018 - 06:35
Hello
User
13/08/2018 - 06:35
Hi
Excelchat Expert
13/08/2018 - 06:35
Welcome
Excelchat Expert
13/08/2018 - 06:35
Can you please show me your file?
User
13/08/2018 - 06:36
Here
[Uploaded an Excel file]
Excelchat Expert
13/08/2018 - 06:36
Thank you, please give me a few minutes.
Excelchat Expert
13/08/2018 - 06:37
Which sheet it is again?
User
13/08/2018 - 06:37
first one
Excelchat Expert
13/08/2018 - 06:38
Thank you, I need a few minutes.
Excelchat Expert
13/08/2018 - 06:42
Just to make sure, you want the count of how many times "Administration" are there in those ranges, right?
User
13/08/2018 - 06:43
Yes, it should count up "administration" and give me the total in a cell.
Excelchat Expert
13/08/2018 - 06:44
Understood, please stay with me.
Excelchat Expert
13/08/2018 - 06:46
=COUNTIF(C5:C37,"*"&"administration"&"*")+COUNTIF(F5:F37,"*"&"administration"&"*")+COUNTIF(I5:I37,"*"&"administration"&"*")+COUNTIF(L5:L37,"*"&"administration"&"*")+COUNTIF(O5:O37,"*"&"administration"&"*")
Excelchat Expert
13/08/2018 - 06:46
Please use this formula
User
13/08/2018 - 06:47
perfect. I was missing the +'s. Thank you so much
Excelchat Expert
13/08/2018 - 06:47
I'm glad to help
Excelchat Expert
13/08/2018 - 06:48
Please rate me 5 star if you think my service was helpful.
User
13/08/2018 - 06:48
Will do.
Excelchat Expert
13/08/2018 - 06:48
You need to close the chat by clicking on END button to rate me.
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.