How to solve the summary of data between one row of listview?

jeffchang

My table is made with listview. There are four spaces on the top line, such as A, B, C, D. I want to add A + B, C + D to E and F, they are all on the same line, because there is Maybe there is no data in ABCD, it may be character type at this time, I don't know how to add it? Because I enter A + B, C + D, and data can be added at the same time. If there is no one, they will not be added! Thank you!

wufuyi

Perform Val conversion on the data in each column:
Column E = Val (Column A) + Val (Column B)
The Val function will automatically convert the character form to Double type, and will not report an error because it cannot be directly converted