Forum Discussion
YSCOD225
Jul 23, 2022Copper Contributor
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 ...
- Jul 23, 2022
YSCOD225 remove the quotation marks surrounding 1000 and 0. That creates texts and SUM ignores those. That's why you get zero.
Detlef_Lewin
Jul 23, 2022Silver Contributor