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
May you please forward the file your working on so I can help you with your concern?
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
sorry miss read your question
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.
