http://blogs.technet.com/b/heyscriptingguy/archive/2006/04/06/how-can-i-locate-and-replace-information-for-a-specific-item-in-a-spreadsheet.aspxHey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer? -- BB Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scriptingen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/heyscriptingguy/archive/2006/04/06/how-can-i-locate-and-replace-information-for-a-specific-item-in-a-spreadsheet.aspx#3542544Tue, 25 Dec 2012 07:04:42 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3542544Abby<p>How can i sum up the two cell in column C when the the code is match in column A</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3542544" width="1" height="1">