I need an excel formula. No one can help me, so I'm coming
to you. I need to do an "exclusive" formula in the total
column on an excel sheet. For example. If column A4 to A55
has a number greater than 0 in it, then it is exclusive to
columns b, c and d and adds up in the total column. And
then I have to do the same for the other three columns.

Can anyone help me?