Stop VSTACK from turning blanks to 0s

Hi!
I have a sheet with lots of tables with measurements that I add together with VSTACK(). These measurements can be 0 and also blank. However, when I put them together, VSTACK() turns all the blanks to 0's.

Is there a way to prevent this?

Any leads are very appreciated!
Adrian

Pls try this formula

Formula:

Please Login or Register  to view this content.

Another option that keeps the values as numbers

Formula:

Please Login or Register  to view this content.

Both of you - thank you so much! This was really helpful. I ended up choosing the IF()-function, as it allowed me to do more calculations on the resulting array, but both options was efficient at solving the issue I asked for.

Have a great day!
Adrian

Glad to help & thanks for the feedback.

@adrianostlund You're Welcome. Glad to help . Thank You for the feedback and rep.