help with sum if

Khanh

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.

Paul Newcome

I believe your question has already been answered in your original post.

https://community.smartsheet.com/discussion/95194/adding-in-a-cell-via-if-then