Ray Whalley
New member
- Joined
- Dec 18, 2016
- Messages
- 3
- Reaction score
- 0
- Points
- 0
The sum function will not calculate the sum of a range of cells containing numbers resulting from a range of IF functions. How can I correct this?? Ihave tried all the recommended soluyion to no avail.
Q1 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
Q2 | 5 | 1 | 1 | 1 | 1 | 1 | 5 | 1 | |
Q3 | 6 | 1 | 1 | 1 | 1 | 1 | 5 | 1 | |
Q4 | 7 | 1 | 1 | 1 | 1 | 1 | 5 | 1 | |
Q5 | 8 | 1 | 1 | 1 | 1 | 1 | 5 | 1 | |
Q6 | 9 | 1 | 1 | 1 | 1 | 1 | 5 | 1 | |
25 | ? |