Sum if in Vba

[buckhunt122]

Hey another question, from the peskiest forum member

I understand how the sumif command works but I am trying to write that in a macro without using the .formula method (Because the target ranges may vary in size)

I attached a very simple and straitforward spreadsheet. On sheet 1 you will see a range of list boxes, those list boxes are populated by a known list of applications. The user selects an application from the list box, then puts the estimate next to it, and moves down the list. Each application may be used 1, 5, or 10, or maybe not at all. On the summary tab I want to copy over the names of the used applications, (but only 1 name if the application was used multiple times) and then the sum of the estimates for that application. Like is said it sounds like a basic sumif, but I dont really know how to do it, since Im not sure what the range sizes will be, ahead of time.

Thanks, Owen