I am trying to create a SUMIFS formula that will allow me to pull data from the following columns:
Region: APAC (There are several offices that make up the APAC region)
OfficeHeadCount: Sum Total (For example 8 APAC Offices so want the sum of all their headcount in closed offices)
I have this formula below but keep getting a parsing error.
=SUMIFS(OfficeHeadCount:OfficeHeadCount, Region:Region="APAC", OfficeStatus:OfficeStatus="Closed")
Any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!