Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |