sum in columns
 

I have a register where I have to Insert a "1" if student is present and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

sum in columns
 

On Jul 10, 9:22 am, K11ngy wrote:
I have a register where I have to Insert a "1" if student is present and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

counta should do the trick.

sum in columns
 

This should do what you want.

=COUNTIF(A:A,1)+COUNTIF(A:A,"L")

HTH,
Paul

"K11ngy" wrote in message
...
I have a register where I have to Insert a "1" if student is present and
this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

sum in columns
 

Another one:
=SUM(COUNTIF(A:A,{1,"L"}))

Although, I bet I'd use PCLive's.





K11ngy wrote:

I have a register where I have to Insert a "1" if student is present and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

--

Dave Peterson

sum in columns
 

On Jul 10, 10:01 am, Dave Peterson wrote:
Another one:
=SUM(COUNTIF(A:A,{1,"L"}))

Although, I bet I'd use PCLive's.

K11ngy wrote:

I have a register where I have to Insert a "1" if student is present and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

--

Dave Peterson

counta's simplier.

sum in columns
 

And if I have other codes in that range????

wrote:

On Jul 10, 10:01 am, Dave Peterson wrote:
Another one:
=SUM(COUNTIF(A:A,{1,"L"}))

Although, I bet I'd use PCLive's.

K11ngy wrote:

I have a register where I have to Insert a "1" if student is present and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

--

Dave Peterson

counta's simplier.

--

Dave Peterson

sum in columns
 

COUNTA counts non-blank cells and will not produce accurate results if there
are other cells in the range that contain data other than 1's or L's, .


wrote in message
ups.com...
On Jul 10, 10:01 am, Dave Peterson wrote:
Another one:
=SUM(COUNTIF(A:A,{1,"L"}))

Although, I bet I'd use PCLive's.

K11ngy wrote:

I have a register where I have to Insert a "1" if student is present
and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel
to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

--

Dave Peterson

counta's simplier.

sum in columns
 

On Jul 10, 10:43 am, "PCLIVE" wrote:
COUNTA counts non-blank cells and will not produce accurate results if there
are other cells in the range that contain data other than 1's or L's, .

wrote in message

ups.com...

On Jul 10, 10:01 am, Dave Peterson wrote:
Another one:
=SUM(COUNTIF(A:A,{1,"L"}))

Although, I bet I'd use PCLive's.

K11ngy wrote:

I have a register where I have to Insert a "1" if student is present
and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want Excel
to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

--

Dave Peterson

counta's simplier.

that wasn't in the specs.

sum in columns
 

that wasn't in the specs.

Only the OP can tell but I expect that he might put a zero for a student who
is not present and that would make your formula incorrect whereas the 2
other solutions will work regardless.


--
Regards,

Peo Sjoblom

sum in columns
 

Sorry, but I have to disagree. The OP clearly stated he wanted to add up
the number of ones and "L"s in a range. He did not say there would or could
be anything else in the range (such as headings, subheadings, etc). So we
have to assume. Using the COUNTA function can produce the wrong results if
some of these other factors exist. But by using the COUNTIF function to
count exactly what you are looking for, you reduce the possibility of
incorrect results.


wrote in message
ups.com...
On Jul 10, 10:43 am, "PCLIVE" wrote:
COUNTA counts non-blank cells and will not produce accurate results if
there
are other cells in the range that contain data other than 1's or L's, .

wrote in message

ups.com...

On Jul 10, 10:01 am, Dave Peterson wrote:
Another one:
=SUM(COUNTIF(A:A,{1,"L"}))

Although, I bet I'd use PCLive's.

K11ngy wrote:

I have a register where I have to Insert a "1" if student is present
and this
adds up at bottom of column as usual.

If student is late I want to put "L" in the cell but I also want
Excel
to
add these along with the number "1" as well?#

Any ideas

Thanks

Steve King

--

Dave Peterson

counta's simplier.

that wasn't in the specs.