1. Having difficulty using countif on a SalesAnalysis worksheet to count the number of sales per year by looking at the Year in the Date Sold column on the Ebay inventory sheet,
2. On the Ebay Inventory sheet, having difficulty creating a countif formula in the Date Sold column in a way that allows adding new rows of data without having to change the formula.
3. On the Ebay Inventory sheet, rows 889-894, don't uderstand why #VALUE! appears but not in the rows before and after with the same formula.
Insight will be appreciated.