Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct issues.
I am trying to add an arai of figures together based on customer name and week.
The sheet that I am collecting the data from has a list of invoices and the week when they are due, being pulled in Via SQL query (in case that makes a difference) The client is using Excel 2000, Simply put Customer, Inv_Amount, Week_No I want to display as: Week 1 Week 2 Week 3 Customer xxxxx xxxxx xxxxxx The formula that I have used is as follows. =SUMPRODUCT('Sales Actuals'!$F$2:$F$323,('Sales Actuals'!$B$2:$B$323='Filled Sheets'!$B7)+0,('Sales Actuals'!$L$2:$L$323='Filled Sheets'!L$5)+0) but it does not work and returns a #NA value on all cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct issues.
I'm not sure exactly what this formula is supposed to accomplish. Are you
trying to sum the values in F2:F323 where the adjacent cells in columns B and L match the criteria in Filled Sheets B7 and L5? If so, then maybe this: =SUMPRODUCT(--('Sales Actuals'!$B$2:$B$323='Filled Sheets'!$B7),--('Sales Actuals'!$L$2:$L$323='Filled Sheets'!L$5),'Sales Actuals'!$F$2:$F$323) HTH, Paul -- "Lewiselw" wrote in message ... I am trying to add an arai of figures together based on customer name and week. The sheet that I am collecting the data from has a list of invoices and the week when they are due, being pulled in Via SQL query (in case that makes a difference) The client is using Excel 2000, Simply put Customer, Inv_Amount, Week_No I want to display as: Week 1 Week 2 Week 3 Customer xxxxx xxxxx xxxxxx The formula that I have used is as follows. =SUMPRODUCT('Sales Actuals'!$F$2:$F$323,('Sales Actuals'!$B$2:$B$323='Filled Sheets'!$B7)+0,('Sales Actuals'!$L$2:$L$323='Filled Sheets'!L$5)+0) but it does not work and returns a #NA value on all cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
sumproduct issues | Excel Worksheet Functions | |||
Sumproduct and format issues | Excel Worksheet Functions | |||
Issues with sorting | Excel Discussion (Misc queries) | |||
Protection issues | Excel Discussion (Misc queries) |