View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Adam[_2_] Adam[_2_] is offline
external usenet poster
 
Posts: 1
Default If statement help

Looks like this

Adam 1
Smith 2
Johns 6
adam 3
smith 4
johns 7

What i would like to do is if
Adam matches another adam in list then it adds the 2 together
so in this case adam would = 4