Subtotal while Incorporating IF function Formula

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

daddylonglegs!

Thanks so much for your help! This formula works perfectly. However, I ran into one more pothole, if you have time or someone else has the time to help me. The is one more column I need incorporated into the formula.

Can this also be incorporated into the formula above somehow?

I have THREE columns. One is called ‘Total Line Amount Paid’ (AB), the other called ‘PO Ext Price’ (X), and the third is called 'Est Ext Price' (R). 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. HERE's THE ADDITION I'M REQUESTING TO THE FORMULA PROVIDED DADDYLONGLEGS. IF cells AB as well as X = 0, then add R, otherwise add AB. I'm using subtotal because I'm using a filter and only want to sum the visible cells.

Please assist. Thanks again! This is the last portion that I'm trying to figure out.

mbnewton1