simple macro help

[surfingtonio]

given the following data:

ID----Date----------Amt
1-----Jan 10, 2007---20
1-----Mar 15, 2007---30
1-----Jun 2, 2007---40
2-----Jul 1, 2007----10
3-----Jul 1, 2007----30
4-----Jul 1, 2007----80

i want an excel macro that i can pass a startdate, enddate and an id and will output the sum of the fields under the amt column including the months in between for the specified id.

for example, given the following information:

startdate = jan 1, 2007
enddate = jun 30, 2007
id = 1

the following values would be added together:

jan - 20
feb - 20
mar - 30
apr - 30
may - 30
jun - 40

and would return:

170

[mudraker]

Welcome to excelforum

Please read forum rules & use appropriate thread titles