ExcelBanter - added up none numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - added up none numbers (https://www.excelbanter.com/excel-worksheet-functions/71317-added-up-none-numbers.html)

Sheryl

added up none numbers

I have to add up how many A's, S's, ST's and L's I have in a column how do I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

Bob Phillips

added up none numbers

=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a column how do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

Peo Sjoblom

added up none numbers

Or maybe countif

=COUNTIF(A:A,"A")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

"Bob Phillips" wrote in message
...
=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a column how
do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

Bob Phillips

added up none numbers

oh alright then :-)

"Peo Sjoblom" wrote in message
...
Or maybe countif

=COUNTIF(A:A,"A")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

"Bob Phillips" wrote in message
...
=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a column how
do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

bpeltzer

added up none numbers

Use the countif function: =countif(A:A,"A")+countif(A:A,"S"),...

"Sheryl" wrote:

I have to add up how many A's, S's, ST's and L's I have in a column how do I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

Sheryl

added up none numbers

I tried those and they did not work
=COUNTIF(A:A,"A")
which letters do I change for the column I'm in? They will be columns H thru
BU
Sheryl
thank you for all your help

"Bob Phillips" wrote:

oh alright then :-)

"Peo Sjoblom" wrote in message
...
Or maybe countif

=COUNTIF(A:A,"A")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

"Bob Phillips" wrote in message
...
=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a column how
do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

Bob Phillips

added up none numbers

=COUNTIF(H:BU,"A")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I tried those and they did not work
=COUNTIF(A:A,"A")
which letters do I change for the column I'm in? They will be columns H
thru
BU
Sheryl
thank you for all your help

"Bob Phillips" wrote:

oh alright then :-)

"Peo Sjoblom" wrote in message
...
Or maybe countif

=COUNTIF(A:A,"A")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

"Bob Phillips" wrote in message
...
=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a column
how
do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

sheryl

added up none numbers

So for column H this is what I tired

=COUNTIF(H2:H24,"A")

and it worked

but for the next section I tired

=COUNTIF((((H25:H41,"A")(((H25:H41,"S")))((H25:H41 ,"LO"))(H25:H41,"L"))))

and it did not. What did I do wrong?

I need how many A's, S's and L's

"Bob Phillips" wrote:

=COUNTIF(H:BU,"A")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I tried those and they did not work
=COUNTIF(A:A,"A")
which letters do I change for the column I'm in? They will be columns H
thru
BU
Sheryl
thank you for all your help

"Bob Phillips" wrote:

oh alright then :-)

"Peo Sjoblom" wrote in message
...
Or maybe countif

=COUNTIF(A:A,"A")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

"Bob Phillips" wrote in message
...
=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a column
how
do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

Bob Phillips

added up none numbers

=SUMPRODUCT(COUNTIF(H25:H41,{"A","S","LO","L"}))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"sheryl" wrote in message
...
So for column H this is what I tired

=COUNTIF(H2:H24,"A")

and it worked

but for the next section I tired

=COUNTIF((((H25:H41,"A")(((H25:H41,"S")))((H25:H41 ,"LO"))(H25:H41,"L"))))

and it did not. What did I do wrong?

I need how many A's, S's and L's

"Bob Phillips" wrote:

=COUNTIF(H:BU,"A")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I tried those and they did not work
=COUNTIF(A:A,"A")
which letters do I change for the column I'm in? They will be columns
H
thru
BU
Sheryl
thank you for all your help

"Bob Phillips" wrote:

oh alright then :-)

"Peo Sjoblom" wrote in message
...
Or maybe countif

=COUNTIF(A:A,"A")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

"Bob Phillips" wrote in
message
...
=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a
column
how
do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

sheryl

added up none numbers

I tried that all I got was a 3 and I should have L=2, S=3, A=9 and LO=0

"Bob Phillips" wrote:

=SUMPRODUCT(COUNTIF(H25:H41,{"A","S","LO","L"}))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"sheryl" wrote in message
...
So for column H this is what I tired

=COUNTIF(H2:H24,"A")

and it worked

but for the next section I tired

=COUNTIF((((H25:H41,"A")(((H25:H41,"S")))((H25:H41 ,"LO"))(H25:H41,"L"))))

and it did not. What did I do wrong?

I need how many A's, S's and L's

"Bob Phillips" wrote:

=COUNTIF(H:BU,"A")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I tried those and they did not work
=COUNTIF(A:A,"A")
which letters do I change for the column I'm in? They will be columns
H
thru
BU
Sheryl
thank you for all your help

"Bob Phillips" wrote:

oh alright then :-)

"Peo Sjoblom" wrote in message
...
Or maybe countif

=COUNTIF(A:A,"A")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon

"Bob Phillips" wrote in
message
...
=SUMIF(A:A,"A")

etc.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Sheryl" wrote in message
...
I have to add up how many A's, S's, ST's and L's I have in a
column
how
do
I
do that?
Column 1 Column 2
A A
A
A A
ST A
A A
A A
A A
A
A
A A
A A
A A
A A
A
L L
A A
A A
A
A A
S S
S S
A A

All times are GMT +1. The time now is 07:16 PM.