IF or Case Function?
I am trying to add up a company cost by project in multiple branches. What function should I use?
For example - i have already totaled up quarterly spend and total spend for each company in each location. If I wanted to add up the location spend keeping it under the project (since the company is working on more than one project), how could I calculate that?
I was trying to use an IF function, but unless i specifically write in the names of the project and company, such as IF project = "Apple" and vendor = "orange" ; sum of total location spend ; i can't get it to work. And there are too many combinations of company and project to do this.