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.
posted by cheechman85 to Computers & Internet (2 answers total) 1 user marked this as a favorite