Hi Guys

I have an excel spreadsheet (2010) with a Subtotal on the Revenue column.

I am trying to create a formula to basically say.


Show me the total revenue for all Joe's customers that are still "Pending".

I have tried everything I can think off.

May Thanks
Fentoei