help with sum if

I am hoping to sum up the amount in the P&I Amount Colum if the Status Colum is Confirmed or Needs Org Profile Updates, or Summited (under review), or etc. in the Total Approved cell row 43 and column P&I Amount.

I think it is a sumif formula. The formula I currently have is =SUMIF(Status1:Status42, "Confirmed", [P&I Amount]1:[P&I Amount]42 but I would like it to search the whole Status Column and the whole P&I Amount column.

Please help.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!