| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assigning numbers to text and count them | Excel Discussion (Misc queries) | |||
| Count numbers within text | Excel Worksheet Functions | |||
| IF Then using a column of text and assigning a number to text | Excel Discussion (Misc queries) | |||
| Count, numbers and text | Excel Discussion (Misc queries) | |||
| assigning numbers to text entries | Excel Discussion (Misc queries) | |||
![gimme_donuts[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
