Hello,
I have a question regarding summing up some values in a column, which are separated by a slash. How can this be achieved???
The column looks like:
4 / 6
5 / 2
2 / 3
4
2 / 1
3
I want these cells to be summed up like:
20 / 12
This means, empty cells should be considered as "0". Cells, which are not separated, should be added to the "first" sum.
Personally, I would split up this column to two different columns - but it's an official template form. I may not change the design, but the functionality.
I hope, to get some help here
Thank you in advance,
C.
Bookmarks