List total sales by region, person or date - Possible VLOOKUP solution?

Originally Posted by hemesh

Hello DVS Try Pivot Tables

Thanks Hemesh but was looking to avoid pivots as other users might not know how to use it. The SUMIFs solution from Kaper solved this problem.