Thread: sum in columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] BartParry@gmail.com is offline
external usenet poster
 
Posts: 6
Default 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.