All,

Thank you in advance for your help!

I have two columns. One is called ‘Total Line Amount Paid’ (AB) and the other called ‘PO Ext Price’ (X). I want to subtotal all of column AB and include an IF function with it. For instance, if AB=0, then add X, otherwise add AB. I'm using subtotal because I'm using a filter and only want to sum the visible cells.

Here's my start with both formulas. How do I incorporate them? The formula will be on a different tab called Template. The Excel data where the data comes from is called Detail Orders (which will be filtered).

=SUBTOTAL(9,'Detail Orders'!AB:AB)
=IF('Detail Orders'!AB:AB=0,'Detail Orders'!X:X,'Detail Orders'!AB:AB)

Please let me know if I need to explain it better. Thanks again.

mbnewton1