sum of columns is not work because of empty data

[#1]

Hi,

I try to sum Column 1+Column 2+Column 3 in a seperate column by using formula option of jmp. But sometimes some rows results are empty. due to that formula editor is not calculate the result. Could you please help for it?

Please find enclosed jmp file as an example to explain my issue.

[#2 · Accepted solution]

Have you tried using Sum formula:

Sum(:Column 1, :Column 2, :Column 3)

[#3 · Accepted solution]

Use

sum( :column 1, column 2, :column 3);

The Sum() function ignores missing values