View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mosqui Mosqui is offline
external usenet poster
 
Posts: 10
Default Sumif but taking a value

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.