I have two columns with titles Name and Job Number respectively. The third column contains cost information. I want to sum the total cost for each name and job number. The following forumula works but due to the vast amount of data I am working with, the time it takes to run is extremely long.

=SUM(IF($B$1:$B$200000=$B1, IF($A$1:$A$200000=$A1, $E$2:$E$200000,0),0))

I was wondering if there is a vba code I could use to speed the process up...