One of the cells I wish to sum is a formula and does not sum. Thank you.
N NeverBoring Oct 3, 2009 #1 One of the cells I wish to sum is a formula and does not sum. Thank you.
T T. Valko Oct 3, 2009 #2 Remove the quotes from around any numbers in your formula. Right: =IF(A1="x",10,0) Wrong: =IF(A1="x","10","0")
Remove the quotes from around any numbers in your formula. Right: =IF(A1="x",10,0) Wrong: =IF(A1="x","10","0")
