bit long .....

assumed B2:E2 has yes,no,sometimes,maybe.....

in F2 put this formula ( use ctrl + shift + enter )

=SUMPRODUCT(IF(B2:E2="yes",1,IF(B2:E2="no",0,IF(B2 :E2="sometimes",
0.5,IF(B2:E2="Maybe",0.25)))))


On Nov 17, 11:09*am, gimme_donuts
wrote:
it has to be very easy but I have not found the way to do it.

What I'm tryig to do is some list of companies and for their services I want
to use Yes for 1, No for 0, Sometimes for 0.5 and Maybe for 0.25.

just asigning these numbers to the text is what I want, so that it is easely
readable and editable for everyone and it still can make some addition of it
in the end.

Example:

Kwik e-mart * *Fruits * - *Vegetables *- Meat *- Fish - *Fresh * * * Total
score
* * * * * * * * * * * * * *Yes * * * * *Yes * * * *Sometimes * *No *Maybe * *
* 2.75

To add this data, I used the validation function so that there is a dropdown
menu for each criteria (Yes, No, Sometimes, Maybe)