Help!! Need help with multiple sumifs formula
I need multiple sum ifs function help. Right now I have the * I believe* correct formula to look up 1 item in a column and it is providing the right output. But I need it to look up multiple/search for multiple in a column.
=SUMIFS([Total of Previously Approved Change Orders]@row + [Change Order Amount]@row, [Branch Number]@row, "5005", [Approved / Denied]@row, "Approved")
I need it to look up multiple different 'branch numbers' (bolded) , so for example I would need it to look up 5005, or 2008, or 2014, etc. There are multiple drop down options in this column that I need summed if it matches.
Help Article Resources
Check out the Formula Handbook template!