i have a master dataset that has a column called status in Column T. In
Column N I have an invoice amount.
If the status is "cleared" then I do not want the subtotal to include the
invoice amount, thus if there is no value (blank) in column T then I want the
equivilent column N invoice amount to be included in the subtotal.

How can i accomplish this without using a filter?