I have a class list in Excel.
About half of the class are seniors the others juniors. In the fist colomn there's a number(1-27) the second colonm is the rank(senior or junior) and the third colomn is the attendence for a single day(sept. 13) . What formula would i use to calculate how many seniors and how many juniors have attended on a certain date. I need these numbers separately, seniors in one cell and juniors in another.
Maybe there's a way to do it simpler in Access... any ideas?
Thank you in advance