4 Replies Latest reply on Feb 9, 2015 5:20 AM by philmodjunk

    IF or Case Function?



      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.