abc is always in m. The relation between the first column and the unit is
always the same. Has to be simple. Is like an IF but as abc is repeated a few
times I need something more powerful.

thanks


"T. Valko" wrote:

Need more info.

I'm assuming the unit is the right column?

So, the unit for abc is m. So, what do you want to do with m? What if there
are more than one units for abc?

Need details!

--
Biff
Microsoft Excel MVP


"Mosqui" wrote in message
...
Must be pretty simple but not sure how to do it.
I have a sumif function doing a summary of quantities, but I also need to
get the unit used in these quantities.
abc 5 m
ert 3 l
dfg 9 m2
abc 7 m
dfg 6 m2

With sumif in my summary I now I have 12 abc, but I need the unit in a
column too.



.