Is there a formula that will summarize data without having to use a pivot
table?

I want it to summarize like a pivot table without using one? Perhaps a
vlookup or index, or match formula?