assigning numbers to text and count the text

[gimme_donuts]

follow up for this post, go there to check up in mre detail
http://www.microsoft.com/office/com...5cdfc030b30&cat=&lang=en&cr=US&sloc=en-us&p=1


quick reformulating: how can I count easier than this
= Indirect(b1)+Indirect(b2)+...+Indirect (b200)

The other post has two replies/solutions but I cant make them work.
Thanks for your help!

 

[Joerg Mochikun]

Your postings are not clear. From your previous post:

hey is there a way to simplify the formula
=INDIRECT(B1)+INDIRECT(C1)+INDIRECT(D1) ????

Do you want to sum across a row B11 or down a column B1:B200?

Anyway you dont need to use INDIRECT.
Since you have only 4 criteria (Yes for 1, No for 0, Sometimes for 0.5 and
Maybe for 0.25), you could use something like
=SUM(COUNTIF(B1:B200,"Yes"),COUNTIF(B1:B200,"Sometimes")*0.5,COUNTIF(B1:B200,"Maybe")*0.25)


Cheers

Joerg

 

[gimme_donuts]

actually i have 6 criteria, but yourformula works very well!
Thank you!