Hi,

So I have a sheet with about 8 columns...

I set countDict=CreateObject("Scripting.Dictionary")

data = ActiveSheet.UsedRange 'Here I am assuming all my 8 columns will come in...
So I populate the dictionary 

For i = LBound(data,1) To UBound(data,1)

Name = data(i,1)
Age= data(i,2)
Team = data(i,3)
Wins = data(i,4)
So there are people with the same name and same age and same team... and for when these are the same in my data across the row, I want to tally the win.


So I am trying something like...

If countDict.exists(name) then 
countDict(Wins) = countDict(Wins) + value
But this above expression only takes into account the name... can I make it so that some how it can match several columns?