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...
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...
Hi Sam
This is showing a sum of 0 because you have entered "1", "2, "3" with quotes instead of the number.
PC interprets the characters between quotes as text.
Please replaces the IF formula accordingly for example :
From this =IF(AND(C4>550,C4<=650),"3","")
To this =IF(AND(C4>550,C4<=650),3,"")
This is showing a sum of 0 because you have entered "1", "2, "3" with quotes instead of the number.
PC interprets the characters between quotes as text.
Please replaces the IF formula accordingly for example :
From this =IF(AND(C4>550,C4<=650),"3","")
To this =IF(AND(C4>550,C4<=650),3,"")