Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and sorting
I have no problems with the sumproduct formula itself, however, once I get
the information i need into a table, the information is compromised when i try to sort the columns. E.G. Sumproduct returns the following results Constant Sumproduct result Company 1 15 Company 2 10 Company 3 16 Company 4 5 When i try to sort the information by result, I get something like Constant Sumproduct result Company 1 16 Company 2 15 Company 3 10 Company 4 5 Can anyone help me with this? Also, would your answer differ if there were mutiple columns that had a sumproduct result? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and sorting
Let's have a look at one fo your Sumproduct formulas.
-- "Lauren" wrote in message ... I have no problems with the sumproduct formula itself, however, once I get the information i need into a table, the information is compromised when i try to sort the columns. E.G. Sumproduct returns the following results Constant Sumproduct result Company 1 15 Company 2 10 Company 3 16 Company 4 5 When i try to sort the information by result, I get something like Constant Sumproduct result Company 1 16 Company 2 15 Company 3 10 Company 4 5 Can anyone help me with this? Also, would your answer differ if there were mutiple columns that had a sumproduct result? Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and sorting
Actually, it doesn't look like you're including the "Constant" Column in
your sorting range. -- "Lauren" wrote in message ... I have no problems with the sumproduct formula itself, however, once I get the information i need into a table, the information is compromised when i try to sort the columns. E.G. Sumproduct returns the following results Constant Sumproduct result Company 1 15 Company 2 10 Company 3 16 Company 4 5 When i try to sort the information by result, I get something like Constant Sumproduct result Company 1 16 Company 2 15 Company 3 10 Company 4 5 Can anyone help me with this? Also, would your answer differ if there were mutiple columns that had a sumproduct result? Thanks! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and sorting
Right - sorry about that, maybe that's not the exact answer but i want
everything to sort together, ie Constant Sumproduct result Company 3 16 Company 1 15 Company 2 10 Company 4 5 but it's not working, the informaiton is being compromised and i don't know how to keep all the results and companies matched up, even when i try to sort. "PCLIVE" wrote: Actually, it doesn't look like you're including the "Constant" Column in your sorting range. -- "Lauren" wrote in message ... I have no problems with the sumproduct formula itself, however, once I get the information i need into a table, the information is compromised when i try to sort the columns. E.G. Sumproduct returns the following results Constant Sumproduct result Company 1 15 Company 2 10 Company 3 16 Company 4 5 When i try to sort the information by result, I get something like Constant Sumproduct result Company 1 16 Company 2 15 Company 3 10 Company 4 5 Can anyone help me with this? Also, would your answer differ if there were mutiple columns that had a sumproduct result? Thanks! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sumproduct and sorting
Also - here's the formula.
+SUMPRODUCT(--('To make pivot table with'!$B$4:$B$3150='Discounted '!$F$5),--('To make pivot table with'!$D$4:$D$3150='Discounted '!A7)*('To make pivot table with'!$AK$4:$AK$3150)) The constant in this case would be cell A7. Thanks. "Lauren" wrote: Right - sorry about that, maybe that's not the exact answer but i want everything to sort together, ie Constant Sumproduct result Company 3 16 Company 1 15 Company 2 10 Company 4 5 but it's not working, the informaiton is being compromised and i don't know how to keep all the results and companies matched up, even when i try to sort. "PCLIVE" wrote: Actually, it doesn't look like you're including the "Constant" Column in your sorting range. -- "Lauren" wrote in message ... I have no problems with the sumproduct formula itself, however, once I get the information i need into a table, the information is compromised when i try to sort the columns. E.G. Sumproduct returns the following results Constant Sumproduct result Company 1 15 Company 2 10 Company 3 16 Company 4 5 When i try to sort the information by result, I get something like Constant Sumproduct result Company 1 16 Company 2 15 Company 3 10 Company 4 5 Can anyone help me with this? Also, would your answer differ if there were mutiple columns that had a sumproduct result? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
using SUMPRODUCT | Excel Worksheet Functions | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
SUMPRODUCT Help | Excel Worksheet Functions |