PC Review


Reply
Thread Tools Rate Thread

How can I caculate text in a column?

 
 
=?Utf-8?B?Q2FsY3VsYXRpb24gb2YgVGV4dA==?=
Guest
Posts: n/a
 
      11th Apr 2006
I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
Can these be added up like #'s in the column?
 
Reply With Quote
 
 
 
 
Don Guillett
Guest
Posts: n/a
 
      11th Apr 2006
try
=countif(a:a,"x")

--
Don Guillett
SalesAid Software
http://www.pcreview.co.uk/forums/(E-Mail Removed)
"Calculation of Text" <Calculation of (E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
> Can these be added up like #'s in the column?



 
Reply With Quote
 
 
 
 
=?Utf-8?B?S2V2aW4gQg==?=
Guest
Posts: n/a
 
      11th Apr 2006
You can use the length function to determine the number of characters in the
cell and then sum those values.

The formula below sums the length of the value in A2, to the lengths of the
value in A3 and so on.

=SUM(LEN(A2),LEN(A3),LEN(A4),LEN(A5))
--
Kevin Backmann


"Calculation of Text" wrote:

> I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
> Can these be added up like #'s in the column?

 
Reply With Quote
 
=?Utf-8?B?VG9wcGVycw==?=
Guest
Posts: n/a
 
      11th Apr 2006
Something like?

=countif(A1:A100,"=X")

=countif(A1:A100,"=XX")*2

etc

HTH


"Calculation of Text" wrote:

> I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
> Can these be added up like #'s in the column?

 
Reply With Quote
 
=?Utf-8?B?Q0xS?=
Guest
Posts: n/a
 
      11th Apr 2006


=COUNTIF(A:A,"x")+COUNTIF(A:A,"xx")*2+COUNTIF(A:A,"xxx")*3

Vaya con Dios,
Chuck, CABGx3



"Calculation of Text" wrote:

> I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
> Can these be added up like #'s in the column?

 
Reply With Quote
 
Don Guillett
Guest
Posts: n/a
 
      11th Apr 2006
Actually, this is probably what you wanted.

=SUMPRODUCT(--(LEN(H2:H50)-LEN(SUBSTITUTE(H2:H50,"x",""))))

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"Calculation of Text" <Calculation of (E-Mail Removed)> wrote
in message news:(E-Mail Removed)...
>I have columns where I have used X's as tick marks. X=1, XX=2, XXX=3, etc.
> Can these be added up like #'s in the column?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
I Want to Caculate only ONE Cell !!! Mahmoud Metwally Microsoft Excel Programming 3 6th Mar 2005 09:34 PM
How to caculate subtotal of every other lines Amolin Microsoft Excel Misc 8 23rd Jul 2004 09:47 AM
Caculate Text JT Microsoft Access Queries 2 12th Mar 2004 01:53 AM
Caculate the rate of return on a mortage purchased at a discount.Third Request JIm Crary Microsoft Excel Misc 2 8th Oct 2003 12:54 PM
caculate workdays accurately Derek Davlut Microsoft Excel Discussion 1 25th Sep 2003 07:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:40 PM.