Good Evening,
Hope all is well!
i have 2 tables:
1st table is for 1 product code: I have hit a brick wall. For example I am trying to get an average age of a product code that is 60 months or under and that has a "YES" in the warranty column in the year 2013.
My formula is
i have another 3 cells that i want an average of
1. The above
2. The average of the product code for all years for number 1.
3. The average of the product code regardless of age and if in warranty
4. the average of the product for all years that is under 60 months and yes in warranty
2nd table: Is for all codes and same as 1 to 4 above.
Any help will be most welcome and appreciated.
I have attached a spreadsheet as an example which i hope explains my wishes.
Thank you for taking your time out and taking a look.
Bookmarks