# Summing letters that equal numbers

1. ## Summing letters that equal numbers

Can anyone provide a formula to sum letters that equal numbers? I would like to sum H=.50 and D=1 in a range of cells.  Register To Reply

2. ## Re: Summing letters that equal numbers

Try this...

=SUM(COUNTIF(A2:A10,{"D","H"})*{1,0.5})  Register To Reply

3. ## Re: Summing letters that equal numbers

That didn't work. I am using a calendar to count days and half days that employees work. Would it interfere with your formula if there were numbers in some of the cells? I only want it to sum what the letters are equal to.  Register To Reply

4. ## Re: Summing letters that equal numbers Originally Posted by M. McGee Would it interfere with your formula if there were numbers in some of the cells?
Yes!

How about posting SEVERAL representative examples so we can see what we're dealing with.  Register To Reply

5. ## Re: Summing letters that equal numbers

I have attached an example of what I am trying to do.  Register To Reply

6. ## Re: Summing letters that equal numbers

There are no D's or H's anywhere in that book (not counting text strings like Wed and Thur and December and March)  Register To Reply

7. ## Re: Summing letters that equal numbers

Sorry. Here is the correct example.  Register To Reply

8. ## Re: Summing letters that equal numbers

The formula I suggested does what you want you just need to use the correct range.

Entered in K5 and copied down:

=SUM(COUNTIF(A5:J5,{"D","H"})*{1,0.5})

You just need to adjust for the correct range for each of your monthly sections.  Register To Reply

9. ## Re: Summing letters that equal numbers

Thank you so much!  Register To Reply

10. ## Re: Summing letters that equal numbers

You're welcome!   Register To Reply