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.