Excel sum question with if and operators
February 26, 2014 3:43 PM Subscribe
Spread sheet contains 4 columns. Submitals, interviews, jobs and a total sum column of the prior three cells mentioned. The trick is, a submital is worth 1 point, a intrerview 3 points, a job 5 points. But the value must be 1 each in its respective column, and the sum column must contain the total number of points. How would you format a sheet to achieve this.