Excel foruma for Exclusive numbers
 

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?

Excel foruma for Exclusive numbers
 

=Sumif(A4:A55,"0")

--
Regards,
Tom Ogilvy

Donna wrote in message
...
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?