add to a count based on a range of values

April 19, 2011 at 10:50:55
Specs: Windows XP
I have an excel worksheet set up for a group of students to track absences. My columns are Student Name, # of absences, # lateness'. Each day I sort in the days absences. After the sort any student that was absent that day will have two consecutive records. What I do now is go through the worksheet manually (400 records) and if the absence code that is on the days absence record is of a certain value, I will add 1 to the # of absences column for that student. This works ok and doesn't take too much time but I know there has to be a way to do it automatically. I have no problem will basic formulas but this has me stumped.

See More: add to a count based on a range of values

Report •


#1
April 19, 2011 at 12:18:14
if the absence code that is on the days absence record is of a certain value

Sorry, don't follow what your trying to do.

Post a small sample of your work sheet, with a before & after if possible.

First read this:
http://www.computing.net/howtos/sho...

It will show you how to post in these forums using the PRE tags.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question