D
Debbie Amateur
Bob Phillips said:
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debbie Amateur
Hi - I'm using the Count If formula you mentioned below...My question is - if
you are summing text and you want the formula to be maintained if you add
columns in later, how do you do that? For example, if I am counting the
number of x's in columns A1:A10 and I add a column at A5, I want to be sure
it automatically includes those in the sum and that the formula now covers
A1:A11....
you are summing text and you want the formula to be maintained if you add
columns in later, how do you do that? For example, if I am counting the
number of x's in columns A1:A10 and I add a column at A5, I want to be sure
it automatically includes those in the sum and that the formula now covers
A1:A11....
T
T. Valko
The formula should automatically adjust for the inserted ROW.
=COUNTIF(A1:A10,"x")
If I insert a new ROW 5 the formula automatically adjusts to:
=COUNTIF(A1:A11,"x")
=COUNTIF(A1:A10,"x")
If I insert a new ROW 5 the formula automatically adjusts to:
=COUNTIF(A1:A11,"x")
G
Genie Lindstrom
I just tried this and it worked perfectly! Thank you!
M
MarieE
I have another instance that I need help with.
I have a string of letters in 1 cell and I want to count how many times a
letter occurs in that cell and eventually count all occurances of all letters
in that one cell. Any ideas?
As an example:
A1 contains "catgctagccatgca" as text. I want to know many times a, c, g,
and t occurs in that string.
I have a string of letters in 1 cell and I want to count how many times a
letter occurs in that cell and eventually count all occurances of all letters
in that one cell. Any ideas?
As an example:
A1 contains "catgctagccatgca" as text. I want to know many times a, c, g,
and t occurs in that string.
P
p45cal
I have another instance that I need help with.
Say your string is in cell A1
in cells A3 downwards enter the letters of the alphabet:
a
b
c
d
etc.
Uppercase too if you want. Or just the specific letters you're lookin
for.
Then in cell B3 enter this formula:
=LEN($A$1)-LEN(SUBSTITUTE($A$1,A3,""))
and copy down the column.
This is case sensitive.
To make it case insensitive use:
=LEN($A$1)-LEN(SUBSTITUTE(UPPER($A$1),UPPER(A3),""))
instead.
DNA sequencing?
I have a string of letters in 1 cell and I want to count how many time a
letter occurs in that cell and eventually count all occurances of al letters
in that one cell. Any ideas?
As an example:
A1 contains "catgctagccatgca" as text. I want to know many times a, c g,
and t occurs in that string.
Say your string is in cell A1
in cells A3 downwards enter the letters of the alphabet:
a
b
c
d
etc.
Uppercase too if you want. Or just the specific letters you're lookin
for.
Then in cell B3 enter this formula:
=LEN($A$1)-LEN(SUBSTITUTE($A$1,A3,""))
and copy down the column.
This is case sensitive.
To make it case insensitive use:
=LEN($A$1)-LEN(SUBSTITUTE(UPPER($A$1),UPPER(A3),""))
instead.
DNA sequencing?
C
Chris Reid
Hello Bob,
The below function helped me start out. But I need to add the letters in
each column and give them different values and then subsequently add them for
a total of nurses scheduled. How would I go about creating that function?
Thank you so much for any help you can give.
The below function helped me start out. But I need to add the letters in
each column and give them different values and then subsequently add them for
a total of nurses scheduled. How would I go about creating that function?
Thank you so much for any help you can give.