I need a formula that will look at a table (Problemsummarym1.Assignme
nt) and based on the information in the table will come up with a group name. For example, if the assignment information is Boston or Atlanta it will come back with a group name of East and if the assignment information is Los Angeles or Seattle it will come back with a group name of West.
I also need a sub-total formula that will total the information per group (I am using formulas to get the totals per assignment's category). I know this is probably confusing so I have attached a screenshot of the information I am gathering.
The tables I am using are: