yogi_Compute Row By Row Count Of Number Of Students Registered In Classes Listed In Columns F:K

Google Spreadsheet   Post  #2012

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-08-2016

post by: shcptech:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/osHoc8Nbm2o;context-place=mydiscussions
Count number of non-blank cells with an array?
I saw this asked in another discussion, but the formula did not work for me.

https://docs.google.com/a/shcp.edu/spreadsheets/d/1N6xy4DkhHbP9qndwpSXefc4wjIfASNk1fpwmTgAEJGw/edit?usp=sharing

I would like the first column to count the number of non blank cells in columns F-K and put the result in column A.data in the cells will constantly be updating, and in fact, at some point the contents will be numbers, and I would want to add the values in cells F-K and put the sum in Column A.

Thanks for your help!

Tim

---------------------------------------------------------------------------------------------------------------------