# An Expert Solution to Using the COUNT Function in Excel

Question description:
This user has given permission to use the problem statement for this blog.

I need to be able to count certain letters as numbers and then add them all up =((COUNTIF(P19:P28,"A")*12),(COUNTIF(P19:P28,"B")*12),(COUNTIF(P19:P28,"C")*8),(COUNTIF(P19:P28,"D")*8),(COUNTIF(P19:P28,"E")*12),(COUNTIF(P19:P28,"F")*8),(COUNTIF(P19:P28,"G")*12),(COUNTIF(P19:P28,"H")*8),(COUNTIF(P19:P28,"I")*12)) this is what I was trying to use
Solved by V. F. in 31 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 23/05/2018 - 12:58
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern.
User 23/05/2018 - 12:58
ok
Excelchat Expert 23/05/2018 - 12:59
I understand you need help in formula to count certain letters..
User 23/05/2018 - 01:00
Yes
Excelchat Expert 23/05/2018 - 01:00
Excelchat Expert 23/05/2018 - 01:00
Sorry I just saw the file now
Excelchat Expert 23/05/2018 - 01:01
which cells should I be looking at?
User 23/05/2018 - 01:01
ok so what I am wanting to do is make certain letter correspond with hours
User 23/05/2018 - 01:01
like A = 12
User 23/05/2018 - 01:01
B= 12
User 23/05/2018 - 01:02
C=8
User 23/05/2018 - 01:02
then be able to count them and show hours total
User 23/05/2018 - 01:03
I tried the countif meathod but I could not get that to work
User 23/05/2018 - 01:03
I kept getting that the formula was messed up
Excelchat Expert 23/05/2018 - 01:03
ok, let me check it further
User 23/05/2018 - 01:03
I'm doing a how to video for work and I thought I had the basics haha but it got the best of me
Excelchat Expert 23/05/2018 - 01:04
and your trying to add the formula in cell S4 and T4? Week 1 and Week 2?
User 23/05/2018 - 01:04
c4-I4 ect.
User 23/05/2018 - 01:05
c5-I5
User 23/05/2018 - 01:05
I have a way I can do it but its really convoluted
Excelchat Expert 23/05/2018 - 01:05
Yes those are your cell reference that you want to count but where do you want to put the result?
User 23/05/2018 - 01:05
yes
User 23/05/2018 - 01:05
Excelchat Expert 23/05/2018 - 01:06
or do you want to total it per day?
Excelchat Expert 23/05/2018 - 01:06
no worries
Excelchat Expert 23/05/2018 - 01:06
Can you show me where you're trying to add the formula?
User 23/05/2018 - 01:07
technically the formula I sent you was from another sheet
User 23/05/2018 - 01:07
=((COUNTIF(P19:P28,"A")*12),(COUNTIF(P19:P28,"B")*12),(COUNTIF(P19:P28,"C")*8),(COUNTIF(P19:P28,"D")*8),(COUNTIF(P19:P28,"E")*12),(COUNTIF(P19:P28,"F")*8),(COUNTIF(P19:P28,"G")*12),(COUNTIF(P19:P28,"H")*8),(COUNTIF(P19:P28,"I")*12))
Excelchat Expert 23/05/2018 - 01:07
ok but you just want to be able to count the letters correct?
User 23/05/2018 - 01:07
I was more wanting to see if that was even a possible solution
Excelchat Expert 23/05/2018 - 01:08
Ok I'll show you a sample then
User 23/05/2018 - 01:08
more I want to count the letters as numbers
User 23/05/2018 - 01:08
Anna has 5 A
User 23/05/2018 - 01:08
so 60 hours
User 23/05/2018 - 01:09
Cindy has 52
User 23/05/2018 - 01:10
then I want to be able to add up the 2 weeks in the total
Excelchat Expert 23/05/2018 - 01:11
ok give me a moment to work on your request
User 23/05/2018 - 01:11
I think I might have made it work....
Excelchat Expert 23/05/2018 - 01:12
Oh I see
Excelchat Expert 23/05/2018 - 01:12
I was just starting with this formula: =sum(countif(C4:Q4,"A")*12,countif(C4:Q4,"B")*12)
Excelchat Expert 23/05/2018 - 01:12
Is there anything else that I can assist you with regarding this issue?
Excelchat Expert 23/05/2018 - 01:13
=sum(countif(C4:Q4,"A")*12,countif(C4:Q4,"B")*12,countif(C4:Q4,"C")*8)
Excelchat Expert 23/05/2018 - 01:13
and just add the other criteria
Excelchat Expert 23/05/2018 - 01:15
=sum(countif(C4:Q4,"A")*12,countif(C4:Q4,"B")*12,countif(C4:Q4,"C")*8,countif(C4:Q4,"D")*8,countif(C4:Q4,"E")*12,countif(C4:Q4,"F")*8,countif(C4:Q4,"G")*12,countif(C4:Q4,"H")*12,countif(C4:Q4,"I")*12)
Excelchat Expert 23/05/2018 - 01:16
That's the complete formula
Excelchat Expert 23/05/2018 - 01:16
Are you satisfied with the solution provided?
User 23/05/2018 - 01:17
yeah thats what I ended with as well... however is there a way to make it easier to import the formula for the other line or do you have to go in one by one and fix the range
Excelchat Expert 23/05/2018 - 01:17
=sum(countif(C4:Q4,"A")*12,countif(C4:Q4,"B")*12,countif(C4:Q4,"C")*8,countif(C4:Q4,"D")*8,countif(C4:Q4,"E")*12,countif(C4:Q4,"F")*8,countif(C4:Q4,"G")*12,countif(C4:Q4,"H")*8,countif(C4:Q4,"I")*12)
User 23/05/2018 - 01:17
other lines
Excelchat Expert 23/05/2018 - 01:17
sorry here's the corrected one
Excelchat Expert 23/05/2018 - 01:17
just drag the formula down
User 23/05/2018 - 01:18
thats what I have been trying to do but its not really doing it
User 23/05/2018 - 01:18
or maybe i'm going crazy with my home sheet
Excelchat Expert 23/05/2018 - 01:22
you can double click on the cell with the formula and just drag the ranges
User 23/05/2018 - 01:22
Thanks you are a saint
User 23/05/2018 - 01:22
I think it was just being wonky on my end
Excelchat Expert 23/05/2018 - 01:22
you're welcome :)
Excelchat Expert 23/05/2018 - 01:22
Thanks for using Got It Pro-Excel. Please give your kind feedback for our service. Have a good day! :)
User 23/05/2018 - 01:23
You to!
Excelchat Expert 23/05/2018 - 01:24
Feel free to end this session as soon as you are ready for us to continue helping other customers. Thank you.

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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.