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 1, 2 or 3 based on the date supplied.
I simply want a sum formula in F12 to calculate the total of these scores which appear in cells D2:F2, D4:F4, D6:f6, D8:f8,D10:F10
Screenshot attached for further reference. In this case the sum should be 10
7 Replies
=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
Hi Sam
Enter in the f12 cell:
=SUM(D2:F2,D4:F4,D6:F6,D8:F8,D10:F10)Hi,
This is showing a sum of 0 rather than 10... It doesnt seem to be registering the numbers inputted by the formulas in each of those cells
Formulas are for example : =IF(AND(C4>550,C4<=650),"3","")
This gives a score of 3 in call F4 however the sum function does not seem able to sum these...
Or use
=IMSUM(D2:F2,D4:F4,D6:F6,D8:F8,D10:F10)
if you prefer to keep scores as text
