OK . I am probably overthinking this but here goes.
ON the attached worksheet. Using MS 365 MSO.
On the calculations tab i want to count how many of a specific item has been sold over a given date range that I export from a third party tool.
I will keep adding to the list of sales and would rather not have to go into each formula and update the range whenever it changes.
I am using Countif as that seemed easy enough but if there is a better way I am open to it.
Basically calculate how may times an item in the range "'Sale Details'!$J$2:$J$26" was sold and bring that count into the calculations tab for the respective item.
Does that make sense?
I greatly appreciate any guidance you can give.
Bookmarks