SUM different values in a column

Hello

I'm trying to sum all sales for each state. See attached example.

This is part of a bigger spreadsheet that I'm working on that means that I can't just use a Pivot to sort this.

Can I use SUBTOTAL and SUM to solve this?

Thanks

Tom

I have the same thought, but am unsure of the precise syntax. Are you able to explain that please?

Try

=SUMIF(A:A,"AL",B:B)

But better to have a list of States and replace "AL" with cell reference

=SUMIF(A:A,C1,B:B) where C1="AL"

That's it, thanks. So obvious when it's written out by someone else!