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...
Probably a pivot table would also be great help.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Yes, as oeldere said, Pivot table will be handy.
But if you would like to have some formula help, please upload an excel sheet with mock up data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks