Help for Formula: identify how much is pending in terms of dollar amount.

HI there!

I have an excel report that requires frequent updating. My main objective is to identify how much is pending in terms of dollar amount.
There are multiple columns and rows.

Column A is the Claim number, B is the status, C is the Amount pending, and Column D is the due bucket date ( i usually use 1week due , 2weeks due etc)
If column B does have a comment or status- the amount should not be counted as Pending.
If column B is blank, then it goes to the pending bucket list.

Id like to link the data worksheet to the primary worksheet on the same excel file. Above data with column A-C is on worksheet 2 and the pending report is on worksheet 1.

Does it make sense?

Thanks for the tips! Stay safe and Happy Thanksgiving♥