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.
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.
Try this...
=SUM(COUNTIF(A2:A10,{"D","H"})*{1,0.5})
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
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.
I have attached an example of what I am trying to do.
There are no D's or H's anywhere in that book (not counting text strings like Wed and Thur and December and March)
Sorry. Here is the correct example.
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.
Thank you so much!
You're welcome!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks