Sum of values by criteria from other cells

Microsoft Ms sla excel lic/sa 3yr-1
January 18, 2011 at 06:09:43
Specs: Windows XP
Hello all,

I have two questions, could you please help me:

1. I have many cells with values like that:
25pq5689
25tyu5689
25ter5689
25QD5689
I need to change letters with numbers (every letter correspond to appropriate number like a=02, b=05, etc...), and I expect to have in results:
250564569
255645689
250125689
255895689

2. Next one, I have two columns:
| number | name |
| 29 | N1 |
| 56 | N1 |
| 45 | N1 |
| 58 | N2 |
| 89 | N2 |
| 55 | N3 |
| 65 | N3 |
| 47 | N3 |
| 56 | N4 |
| 10 | N4 |
I need to SUM values from column "number" for N1, N2... from column "name".


See More: Sum of values by criteria from other cells

Report •


#1
January 18, 2011 at 06:37:35
I'm a tad confused by your examples. Some of the "input" values have 2 letters and some have 3, yet your outputs don't seem to match those configurations.

Were those supposed to be one-for-one inputs/outputs?

Is this a 1 time thing or will you have to repeat this conversion on a regualr basis?

As far as your second question, review the Help files for the SUMIF function.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 18, 2011 at 07:29:21
Thank you very much for SUMIF function. For the first ask I found resolution.

Report •
Related Solutions


Ask Question