Forum Discussion
Solved
Sum function.
Sum function. Hello, I used the function if in some column as in image 1 to display 1000 if the value of the left cell ( C5:C22) is greater than 0. Now I want to sum the cells containing the values ...
YSCOD225 remove the quotation marks surrounding 1000 and 0. That creates texts and SUM ignores those. That's why you get zero.
YSCOD225 remove the quotation marks surrounding 1000 and 0. That creates texts and SUM ignores those. That's why you get zero.
- Thanks
