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.

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.

1 Like

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