LinkBack URL
About LinkBacks
Hi,
How can I calculate a row sum based on cells containing letters and the letters represent values.
Row: A1= a, B1=a, C1=b, D1=a, E1=c
a=1
b=2
c=3
A B C D E 1 a a b a c
Row sum would be a+a+b+a+c = 1+1+2+1+3 = 8
Thanks in advance!
Hi,
How can I calculate a row sum based on cells containing letters and the letters represent values.
Row: A1= a, B1=a, C1=b, D1=a, E1=c
a=1
b=2
c=3
A B C D E 1 a a b a c
Row sum would be a+a+b+a+c = 1+1+2+1+3 = 8
Thanks in advance!
Last edited by antmer; 09-03-2013 at 02:45 AM.
1 way creating a table. Something like this let's say in range J2:K5 .
a 1
b 2
c 3
d 4
Then you could use this..
=SUMPRODUCT((A1:E1=J2:J5)*(K2:K5))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks I got it working with =COUNTIF(A1:E1;"a")*C$1+COUNTIF(A1:E1;"b")*D$3 etc. C$1, D$3 etc. is the corresponding value for the letter.
It's a bit ugly but works
Hey Fotis I continued to working with this
but Im having trouble getting it to work. I think I know what you are suggesting here, but does this really work that way?Originally Posted by Fotis1991
Doesnt this require A1:E1 and J2:J5 to be same size? This compares if A1 = J2 is TRUE, B1 = J3 is TRUE etc.
I need it to compare A1 is one of the values in range J2:J5 -> TRUE
Did you test my suggestion?
THANKS!
I had the problem my "letter / number" was horizontal
-----------
a b c d e f
1 2 3 4 5 6
-----------
switched it to
a 1
b 2
c 3
etc. and it works! thanks again
You are welcome and thanks for the feed back.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks