SUMPRODUCT?
 

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

SUMPRODUCT?
 

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

SUMPRODUCT?
 

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

SUMPRODUCT?
 

then
=sumproduct((daternga1)*(daterng<a2))
to count
=sumproduct((daternga1)*(daterng<a2)*valuerng)
to sum between the dates for the values
--
Don Guillett
SalesAid Software

"robo" wrote in message
...
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

SUMPRODUCT?
 

Thanks, got it now!!

"Don Guillett" wrote:

then
=sumproduct((daternga1)*(daterng<a2))
to count
=sumproduct((daternga1)*(daterng<a2)*valuerng)
to sum between the dates for the values
--
Don Guillett
SalesAid Software

"robo" wrote in message
...
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

SUMPRODUCT?
 

glad it helped


--
Don Guillett
SalesAid Software

"robo" wrote in message
...
Thanks, got it now!!

"Don Guillett" wrote:

then
=sumproduct((daternga1)*(daterng<a2))
to count
=sumproduct((daternga1)*(daterng<a2)*valuerng)
to sum between the dates for the values
--
Don Guillett
SalesAid Software

"robo" wrote in message
...
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