u/Even_Independent_975

I need to be able to add from B6 to G6, however sometimes we use * to depict important events (for example 1*), this prevents a regular sum formula from working properly, it will add everything except the number with the *. is there a way to get this to work. bonus points if it can be worked into an array and the formula can be placed into cell h5 and have it work from h6 down (less chances for my coworkers to delete the formula.