|
assigning numbers to text and count the text
follow up for this post, go there to check up in mre detail:
http://www.microsoft.com/office/comm...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! |
assigning numbers to text and count the text
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 B1:D1 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,"Somet imes")*0.5,COUNTIF(B1:B200,"Maybe")*0.25) Cheers Joerg "gimme_donuts" wrote in message ... follow up for this post, go there to check up in mre detail: http://www.microsoft.com/office/comm...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! |
assigning numbers to text and count the text
actually i have 6 criteria, but yourformula works very well!
Thank you! "Joerg Mochikun" wrote: 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 B1:D1 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,"Somet imes")*0.5,COUNTIF(B1:B200,"Maybe")*0.25) Cheers Joerg "gimme_donuts" wrote in message ... follow up for this post, go there to check up in mre detail: http://www.microsoft.com/office/comm...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! |
| All times are GMT +1. The time now is 10:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com