Sum by term

Hi Experts   See attached sample data set I what to sum the Alloc column by term, as a calculater column in my table. The allexcept and ignoring the blanks must remain.    https://www.dropbox.co...