All,
I am new to macro writing - thank you for your help and expertise in advance!
I have two columns. One is called Paid Amount column (AB) and the other called Line Amount columnn (X). I want to total the Paid Amount column with a subtotal formula, but including an IF function. If the Paid Amount cell = 0, then add the Line Amount cell instead. Otherwise, if the Paid Amount is not zero, add the Paid Amount cell. I want to do this with about 400 rows. What is the best way to do this?
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.
=SUBTOTAL(9,'Detail Orders'!AB:AB)
=IF('Detail Orders'!AB:AB=0,'Detail Orders'!X:X,'Detail Orders'!AB:AB)
Thanks!
Bookmarks