What is the best way to do a SUMIF for data that's spread across ~50 sheets? This cannot be done with reports.
My data involves how many hours our clients work in each state. There is overlap because a client may work in more than one state. Each of our 50 state sheets shows which clients work there