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?

Don Guillett
Guest
Posts: n/a

 11th Apr 2006
try
=countif(a:a,"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?

=?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?

=?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?

=?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?

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?

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Mahmoud Metwally Microsoft Excel Programming 3 6th Mar 2005 09:34 PM Amolin Microsoft Excel Misc 8 23rd Jul 2004 09:47 AM JT Microsoft Access Queries 2 12th Mar 2004 01:53 AM JIm Crary Microsoft Excel Misc 2 8th Oct 2003 12:54 PM 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:22 PM.