Sumif for letters instead of numbers

I currently use sumif to return the size value for a size code. If the size value happens to be a letter like s, m, l or xl opposed to 4, 6, 8 or 10, the sumif formula will not bring it back..

Can anyone help.

I guess, you need the countif function.

- Mangesh

Set-up a table with the size codes and corresponding values, let's say in Columns A and B, something like this...

4 Value1
6 Value2
8 Value3
10 Value4
s Value5
m Value6
l Value7
xl Value8

Then use the following formula...

=VLOOKUP(C1,A1:B8,2,0)

...where C1 contains the lookup value (size code).

Hope this helps!

Originally Posted by okanem

I currently use sumif to return the size value for a size code. If the size value happens to be a letter like s, m, l or xl opposed to 4, 6, 8 or 10, the sumif formula will not bring it back..

Can anyone help.