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.
Help Article Resources
Check out the Formula Handbook template!