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!
|