Good Afternoon Ozgrid,
I would like total the number of boxes sent to different states for a given quarter. I am running into trouble when I try to group the sites by state. I'm trying to avoid having to create another list grouping the states and sites together. I am hoping I can use functions to be able to group them together instead. I created a diagram on Sheet3 with the commons links between the three sheets. I would be grateful for any thoughts or guidance.