NEED HELP! I have the following 3 sheets of ...

[Francisco_Marti]

NEED HELP!

I have the following 3 sheets of which Im trying to obtain reports

PROJECTS (sheet) - id - project name

EXPENSES (sheet) - id - project name (ref to PROJECT sheet) - amount - status (request, in process, paid)

SUMMARY EXPENSES (sheet) - id - project name (ref to PROJECT sheet) - Paid expenses

Im using the following formula for the (Paid expenses) column to obtain the total of expenses paid

=SUM(SELECT(Expenses [amount],AND([_THISROW].[project name]=[project name], [Payment Status]=“Paid”)))

this formula works fine at the beginning to provide the total of paid expenses. The problem Im having is that when I change the status of “Status” column in the “Expenses” sheet, from in process to paid; it does not reflect on the “Paid expenses” column of the “Summary expenses” sheet.

any thoughts?