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     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.


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
---------------------------------------------------------------------------------------------------------------------