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.


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=470696