I have two columns of data that I am trying to work with. For example:
Days in Stock // Cost
2 // $300
114 // $500
33 // $200
7 // $400
31 // $300
102 // $800
What I want to know is the Average cost of items in stock 0-10 days, 11-60 days, 60+ days. So, for 0-10 days I should get an output of $350; for 11-60 days I should get an output of $250; and for 60+ days I should get an output of $650.
TIA for any help.
Days in Stock // Cost
2 // $300
114 // $500
33 // $200
7 // $400
31 // $300
102 // $800
What I want to know is the Average cost of items in stock 0-10 days, 11-60 days, 60+ days. So, for 0-10 days I should get an output of $350; for 11-60 days I should get an output of $250; and for 60+ days I should get an output of $650.
TIA for any help.
Facebook
Twitter