Friday, January 8, 2016

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   Jan-08-2016
post by: shcptech:!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.

I would like the first column to count the number of non blank cells in columns F-K and put the result in column 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!