it was a cumulative values i was looking for. From the start date 1/10/2004
to what ever date was entered on the report.

"Don Guillett" wrote:

if all you want to do is count the suppliers, look at the COUNTIF function.
if all you want to do is sum the values from one date, try the SUMIF
function.
Of course, sumproduct can also do both of these chores, and more.

--
Don Guillett
SalesAid Software

"robo" wrote in message
...
Help please?
I have a colomn of dates - 1/10/2004 to 26/1/2006.
Also a column of suppliers and a coloumn of values.
On a report I want to be able to count the number of suppliers and sum the
value from a date inserted on the report.
Can you help?
Thanks
Rob