Forum Discussion

YSCOD225's avatar
YSCOD225
Copper Contributor
Jul 23, 2022
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 ...
  • Riny_van_Eekelen's avatar
    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.

Resources