this is my problem:

i got a master worksheet and there are a lot of parameters in it. for instance:

i got the

column 1: date
column 2: vehicle num
column 3: km travelled

in the next worksheet,

i want the sum of the distance travelled for each vehicle for that month(e.g september)

the master worksheet is the data base where the end -user will key in the datas daily. but i need to sum the km travelled for each individual vehicle num. How do i do that ? Is there a need to give a unqiue ID for each vehicle and its corresponding date?

i have tired to use sumproduct() but it seems that it cant sum the total for that month only.

i hope that i made myself clear.

any help is greatly appreciated.