• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Need some help coming up with an Excel formula

S

Sterling19

Junior Member
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top