software

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

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

quot;roboquot; gt; wrote in message
...
gt; Help please?
gt; I have a colomn of dates - 1/10/2004 to 26/1/2006.
gt; Also a column of suppliers and a coloumn of values.
gt; On a report I want to be able to count the number of suppliers and sum the
gt; value from a date inserted on the report.
gt; Can you help?
gt; Thanks
gt; Rob
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.

quot;Don Guillettquot; wrote:

gt; if all you want to do is count the suppliers, look at the COUNTIF function.
gt; if all you want to do is sum the values from one date, try the SUMIF
gt; function.
gt; Of course, sumproduct can also do both of these chores, and more.
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;roboquot; gt; wrote in message
gt; ...
gt; gt; Help please?
gt; gt; I have a colomn of dates - 1/10/2004 to 26/1/2006.
gt; gt; Also a column of suppliers and a coloumn of values.
gt; gt; On a report I want to be able to count the number of suppliers and sum the
gt; gt; value from a date inserted on the report.
gt; gt; Can you help?
gt; gt; Thanks
gt; gt; Rob
gt;
gt;
gt;

then
=sumproduct((daternggt;a1)*(daternglt;a2))
to count
=sumproduct((daternggt;a1)*(daternglt;a2)*valuerng)
to sum between the dates for the values
--
Don Guillett
SalesAid Software

quot;roboquot; gt; wrote in message
...
gt; it was a cumulative values i was looking for. From the start date
gt; 1/10/2004
gt; to what ever date was entered on the report.
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; if all you want to do is count the suppliers, look at the COUNTIF
gt;gt; function.
gt;gt; if all you want to do is sum the values from one date, try the SUMIF
gt;gt; function.
gt;gt; Of course, sumproduct can also do both of these chores, and more.
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;roboquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Help please?
gt;gt; gt; I have a colomn of dates - 1/10/2004 to 26/1/2006.
gt;gt; gt; Also a column of suppliers and a coloumn of values.
gt;gt; gt; On a report I want to be able to count the number of suppliers and sum
gt;gt; gt; the
gt;gt; gt; value from a date inserted on the report.
gt;gt; gt; Can you help?
gt;gt; gt; Thanks
gt;gt; gt; Rob
gt;gt;
gt;gt;
gt;gt;
Thanks, got it now!!

quot;Don Guillettquot; wrote:

gt; then
gt; =sumproduct((daternggt;a1)*(daternglt;a2))
gt; to count
gt; =sumproduct((daternggt;a1)*(daternglt;a2)*valuerng)
gt; to sum between the dates for the values
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;roboquot; gt; wrote in message
gt; ...
gt; gt; it was a cumulative values i was looking for. From the start date
gt; gt; 1/10/2004
gt; gt; to what ever date was entered on the report.
gt; gt;
gt; gt; quot;Don Guillettquot; wrote:
gt; gt;
gt; gt;gt; if all you want to do is count the suppliers, look at the COUNTIF
gt; gt;gt; function.
gt; gt;gt; if all you want to do is sum the values from one date, try the SUMIF
gt; gt;gt; function.
gt; gt;gt; Of course, sumproduct can also do both of these chores, and more.
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Don Guillett
gt; gt;gt; SalesAid Software
gt; gt;gt;
gt; gt;gt; quot;roboquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Help please?
gt; gt;gt; gt; I have a colomn of dates - 1/10/2004 to 26/1/2006.
gt; gt;gt; gt; Also a column of suppliers and a coloumn of values.
gt; gt;gt; gt; On a report I want to be able to count the number of suppliers and sum
gt; gt;gt; gt; the
gt; gt;gt; gt; value from a date inserted on the report.
gt; gt;gt; gt; Can you help?
gt; gt;gt; gt; Thanks
gt; gt;gt; gt; Rob
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

glad it helped--
Don Guillett
SalesAid Software

quot;roboquot; gt; wrote in message
...
gt; Thanks, got it now!!
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt;gt; then
gt;gt; =sumproduct((daternggt;a1)*(daternglt;a2))
gt;gt; to count
gt;gt; =sumproduct((daternggt;a1)*(daternglt;a2)*valuerng)
gt;gt; to sum between the dates for the values
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;roboquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; it was a cumulative values i was looking for. From the start date
gt;gt; gt; 1/10/2004
gt;gt; gt; to what ever date was entered on the report.
gt;gt; gt;
gt;gt; gt; quot;Don Guillettquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; if all you want to do is count the suppliers, look at the COUNTIF
gt;gt; gt;gt; function.
gt;gt; gt;gt; if all you want to do is sum the values from one date, try the SUMIF
gt;gt; gt;gt; function.
gt;gt; gt;gt; Of course, sumproduct can also do both of these chores, and more.
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Don Guillett
gt;gt; gt;gt; SalesAid Software
gt;gt; gt;gt;
gt;gt; gt;gt; quot;roboquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Help please?
gt;gt; gt;gt; gt; I have a colomn of dates - 1/10/2004 to 26/1/2006.
gt;gt; gt;gt; gt; Also a column of suppliers and a coloumn of values.
gt;gt; gt;gt; gt; On a report I want to be able to count the number of suppliers and
gt;gt; gt;gt; gt; sum
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; value from a date inserted on the report.
gt;gt; gt;gt; gt; Can you help?
gt;gt; gt;gt; gt; Thanks
gt;gt; gt;gt; gt; Rob
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;