Since I need to update this data calculation frequently, I like the automation of a single formula. Creating a pivot table adds one extra step that a single formula would not, If I could figure out one that will work with this data.