AnsweredAssumed Answered

IF or Case Function?

Question asked by VanessaAnne on Feb 8, 2015
Latest reply on Feb 9, 2015 by philmodjunk

Title

IF or Case Function?

Post

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. 

Outcomes