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 1000 (D5:D22) but I get the value 0 instead of 18000. can you help me to get 18000?
I know that if I use the NB SI function I can count the number of cells and multiply it by 1000 but I want to know how to add the values in cells containing the si function.
Thank you for your help.
pic 1
pic 2
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
