LinkBack URL
About LinkBacks
Hi
The problem is want count the number of word that have to character.
a part of the table is
I have the following values and text in a colum
11
KD
12
CO
13
V
14
KDNM
Hi
The problem is want count the number of word that have to character.
a part of the table is
I have the following values and text in a colum
11
KD
12
CO
13
V
14
KDNM
Try this, where your range is A1:A8:
Formula:
Please Login or Register to view this content.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
The formule count also the numbers that is not what i need i have to count only the text that have len <=2
Maybe this...Originally Posted by glda19
=SUMPRODUCT(--(LEN(A1:A8)<=2),--ISTEXT(A1:A8))
You may have to replace the comma with a semi-colon.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
what means -- in the formula
-- forces a true/false into a 1/0, to be multiplied against the other 1/0 in the LEN formula. Only if both values are 1 will the value add, (1 X 0 = 0)
try it out in excel by typing =true() then =--true()
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
thx for your help
What is better to do it so or to count the bacground collor
It is not a good practice to base calculations on cell formats.
Base the calculation on the cell data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks