Orders to customer overview

I am trying to make an overview of information on customer level. I have a list of orders with email address. The informatie contains text cells and numbers for example quantities. What I would like to do is make a second page where I have a list of unique e-mailadressen. I would like it to lookup information for example the quantities. If there are more order lines it should add all those values up together and return the value. When there is text it should give back the information from the last order entry.

Is there a good way to do this in Numbers.