Community email notifications are disrupted. While we are working to resolve, please check on your favorite boards regularly to keep up with your conversations and new topics.
You need one formula only, vectorize as shown, get the vectorsum from the matrix drop down icon, that will totalize all the individual formulas you had. Units problem to be made coherent.