For simplicity's sake, let's say you have a spread sheet with four columns (each representing a subject: Math, Science, English, History) and twelve rows (each representing an hour of the day: starting at 8AM and ending at 8PM), so there are 48 total cells that will either be filled with the name of a student or left empty.
Is it possible to have the spread sheet set up so that at the bottom of each column it adds up (or counts) every time a name is placed into a cell?
So, for example, if the teacher taught Alan, Andy, and Alice math for three hours of the day, and Bill and Bob science for two hours of that day, and Cathy history for one hour, the student's names would appear in the appropriate cell at the hour they were taught, and--most importantly--there would be a "3" at the bottom of the math column, a "2" at the bottom of the science column, and a "1" at the bottom of the history column (so there is a record of how many hours the teacher is spending teaching each subject).
Thanks for any help! I know spread sheets from back in the days of Lotus 1-2-3, so I'm not sure of the capabilities that today's versions offer.
If you're trying to log each name separately, you may need to chain together a few if conditions.
Counts the number of nonblank cells in cells A2 through A7.
Note that the cell has to be truly blank, or it will get counted. Example: It will count a cell contains one blank space character.
COUNT won’t work for this. It only counts cells containing numerical values and he wants to count cells containing text (student names in his example)
Quote:
That will count the cells that have characters in them.
COUNT won’t work for this. It only counts cells containing numerical values and he wants to count cells containing text (student names in his example)
You are correct, there are 2 COUNT functions, COUNT will count cells with numbers, COUNTA will count non-empty cells. COUNTA is the one Milton will want to use.
p.s.--And I figured it was too detailed a question for simply googling but maybe I'm just not aware of how sophisticated Google has gotten.