Sumif Formula



I'm having problem with my formula below.  If I update the column 2 to reference "Amount Invoiced", it automatically change the formula in Column 1 to "AmountInvoiced".  I need Column 1 to only reference  PO Amount and not Amount Invoiced.   See below sample formula that I input on the sheet.  

Column 1 =SUMIF({FY19 MASTER PO TRACKER Range 1}, $PID@row, {AmountInvoiced}) -  if I change column 2 to "AmountInvoiced, the auto change column 1 as well.  Why?

Column 2=SUMIF({FY19 MASTER PO TRACKER Range 1}, $PID@row, {AmountInvoiced})

Sumif Formula capture.PNG


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!