**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.*