most efficient way to compute outstanding versus paid expenses

[Plasmech]

In the workbook shown below, cell C21 is a simple summation of a list of yearly fixed expenses.

Cell C22 computes the total of all still-outstanding fixed expenses.

Note the clunky, "brute force" formula used in cell C22.

Is there a more powerful, cleaner way to do this?

Thanks for any replies.

Note 01: In the example below, the expense in row 4 is paid, while all others are unpaid (outstanding).

Note 02: I intended to attach the .xlsx file, but the "attach file" option seems to be missing.

 

[kevin9999]

=SUM(C4:C19*D4:D19)

 

[Plasmech]

@kevin9999

Wow. It's that easy.

Thanks!

Excel truly is the best program ever written.

 

[kevin9999]

Happy to help & thanks for the feedback