Thread
:
Assigning number value to letters
View Single Post
#
2
Posted to microsoft.public.excel.programming
Jim May[_3_]
external usenet poster
Posts: 16
Assigning number value to letters
Check out the = SUMIF(A1:A5,"V",B1:B) = 7
ColA ColB
1) S 1
2) S 2
3) V 3
4) V 4
5) EDO 5
HTH
In article
,
at
wrote on 10/16/08 12:59 PM:
Hi I have a spreadsheet where I need certain Letters or groups of
letters to equal a number value and sum it.
I have employees that take a week of V (vacation) that is 8 hours per
day and I need a sum of 40 at the end. It may vary there could be a S
(sick) day or and EDO (earned day off) that is also equivilent to 8.
My other problem is if they take 4 hours of V or 4 hours of S can this
be summed also??
I have tried this formula =SUMPRODUCT(LOOKUP(E3:K3, $O$4:$O$7, $P$4:$P
$7))
but am getting an #N/A. My Spreadsheet is kind of complicated and has
a bunch of different formulas so I am not sure if that may be the
reason I am getting the error or not.
Please help!
This is my first time using this help program and am not sure if I can
attach an example I cant find anywhere but if you email me I can send
you my spreadsheet.
Reply With Quote
Jim May[_3_]
View Public Profile
Find all posts by Jim May[_3_]