If I understand your question right, you want the totals from 5 different
drop down boxes to be displayed in E1.
in E1 type the following
=sum(A1:D1)
now if the dropdown boxes are all 0, E1 should display 0, as soon as you
change one of the dropdown boxes to any other number, E1 should change
accordingly.

Hope that helps and answers your question.

"mahendra2210" wrote:

I am trying to create multiple distribution lists in A1 to D1, all these
distribution lists have different text in them.
Now, my problem is that "Is there any way in excel using which I can get the
result of any combination in cell E1"......

For Example:
If I have 5 different items in each distribution list from A1-D1, it means
that I can have 5X5X5X5=625 possible outcomes. But I know that only certain
number of outcomes are useful for me...let's say... 50 among these all are
useful and I know what are their respective combintions in cell A1-D1.

So, my question is ""Is there any way using whch I can input details for all
these 50 useful outcomes and get their result in cell E1 with the help of my
selection in cell A1-D1""????