Forum Discussion
Sum Function help
Hi, further to my below post. I am trying to create a formula to automatically calculate the sum of inputs from IF/OR functions. In the scorecard these If/Or functions will automatically put in a...
=SUM(D2:F10)
also shall work since in other than score cell is the text, and text is ignored by SUM
Hi,
This doesn't work it just shows the SUM as 0
The 1, 2, 3's are as a result of formulas such as =IF(AND(C4>550,C4<=650),"3","") or similar....
And it seems Sum is not able to count the scores of 1,2 or 3....
That's true as long as it will not be changed to the value
