Extract data from table

Hi everybody,

I have a table (see attachment) from which I need to extract certain data into another sheet. It should be some kind of filtering.

For example: In column P I have a number which corresponds to a certain name in column O. Now I need to extract/compute the sum of Net Revenues (column AA) for that specific person.

Can I do this with PivotTable or what would be the best way to deal with such queries?

Many thanks for your help.

Attachment 452050

I'm getting an invalid attachment warning. Try attaching it using Go Advanced > Manage attachments (or the paperclip icon)