Counting In Column Fields

[xnay]

Hello all, I'm hoping there is a better way to count the number of times the number "2" appears in a column other than the cumbersome code I'm using now??

ie.
{={If{=Sum(Tbl c1)= 2{=COUNT(Tbl c1)} 0}+{If{=Sum(Tbl c2)= 2{=COUNT(Tbl c2)} 0}}

Is there a way that Word can look at the table as a whole similar to the MAX, MIN, or AVERAGE rather than using individual cell references. The problem is when a new row is added to this table, I have to modify the code each time to account for the new cell.

Any ideas will be greatly appreciated

 

[xlhelp]

Please do a search in the forum. This was answered last week. Look for "number of digits"

Member- AAAA Association Against Acronym Abusers

 

[xnay]

thank you

 

[xnay]

I'm not having any luck with Search posts-keywords 'number of digits' Perhaps I'm not searching correctly, can you be more specific with the type of search to use. Thank you

 

[xlhelp]

thread68-1338843


Member- AAAA Association Against Acronym Abusers

 

[xnay]

Will the solutions discussed in that thread work in word 2K3. My apologies for not mentioning that in my initial post. I thought I was in the Word forum.

 

[xlhelp]

I should learn to read. That's one of my downfall. No, I am sorry, I don't know the answer to that. May be someone else can help you.

My apologies for wasting your time.

Member- AAAA Association Against Acronym Abusers

 

[xnay]

It's all good, don't sweat it. I'm thinking that I'll need to introduce a macro or some VBA to accomplish this one because of Word's limitations. Or, Maybe someone else might have an simpler idea. Thanks again xlhelp

 

[MallardVHS]

Hi xnay, and welcome,

If you suspect a VBA problem/solution, TT has a forum dedicated to that. You might want to post your question there.

I'll bet you get a quick, accurate and helpful answer there. It's a TT thing.

Best of luck!

Don

[blue]________________________________________________________
Some folks put their money where their mouth is. I just pay my bill. [/blue]