SUMIFS - Multiple Columns & Status Selections

Stacy Hammons

I need to sum the rows in "Loan Amounts" column when it meets the following criteria: Division = HB and Status = In Process, or On Hold, or Approved. I can get he formula to work when only having one status such as "In Process", but when I try to add the other 2 options I get an error. Can someone help me with this?

L_123

please post your attempted formula when asking questions, as often it can be a simple issue of a missed parenthesis or comma, and it can help us understand what you are trying to do.

Either way, from what you described the formula below should work.

=sumifs([loan amounts]:[loan amounts],division:division,"HB",status:status,or(@cell = "In Process", @cell = "On Hold", @cell = "Approved

L_123

please post your attempted formula when asking questions, as often it can be a simple issue of a missed parenthesis or comma, and it can help us understand what you are trying to do.

Either way, from what you described the formula below should work.

=sumifs([loan amounts]:[loan amounts],division:division,"HB",status:status,or(@cell = "In Process", @cell = "On Hold", @cell = "Approved

Stacy Hammons

Thank you, I meant to copy in the formula. By going off your example, I was able to see what I was missing. It works now, thanks again!