SUMPRODUCT?

R

robo

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
 
D

Don Guillett

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.
 
R

robo

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.
 
D

Don Guillett

then
=sumproduct((daterng>a1)*(daterng<a2))
to count
=sumproduct((daterng>a1)*(daterng<a2)*valuerng)
to sum between the dates for the values
 
R

robo

Thanks, got it now!!

Don Guillett said:
then
=sumproduct((daterng>a1)*(daterng<a2))
to count
=sumproduct((daterng>a1)*(daterng<a2)*valuerng)
to sum between the dates for the values
Click to expand...
 
Top