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

2. ## Re: Summing letters that equal numbers

Try this...

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

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.

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.

5. ## Re: Summing letters that equal numbers

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

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)

7. ## Re: Summing letters that equal numbers

Sorry. Here is the correct example.

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.

9. ## Re: Summing letters that equal numbers

Thank you so much!

10. ## Re: Summing letters that equal numbers

You're welcome!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1