Hi!
I need to sum series of number but not always need all the fields. Without putting zero in each it is not working. Is there any solution to solve this problem?.
Regards.
There is a simple solution for your issue which is to use “coalesce” function
coalesce ( arg , arg ) Returns first non-empty value of the two arg s. Returns an empty string if both are empty or non-existent.
Kindly see the example:
Coalesce_example.xlsx (11.4 KB)
Let me know if you have any question.
Best,
Yasser
2 Likes
Dear brother Yasser Almustafa
It worked very nicely. Thank you so much for your kind support.
Be blessed.
3 Likes
