I am not sure what to call this functionality so I was unable to effectively search, so I appologize if this has been asked and answered before.

For ease of example, here is what I am looking to do.

Worksheet with multiple rows of data.
Column A contains a quantity
Column B contains a qualifier number 1-5

I want to be able to, in a seperate cell, (on another worksheet page, but not the issue) have a list that states:
Qualifier#1: sum of column A rows with column B = 1

And then subsequently, do the same for the other levels of qualifier
Qualifier#2: sum of column A rows with column B= 2
Qualifier#3: sum of column A rows with column B= 3
Qualifier#4: sum of column A rows with column B= 4
Qualifier#5: sum of column A rows with column B= 5


Is this possible and if so how?

thanks in advance.