Thank you very much for the quick reply.
Worked like a charm, all of them but I was looking more for Maqbool's solution. so double thanks.
Is there a way to make the same in Access? to be presented in a report?
-->tt
Thank you very much for the quick reply.
Worked like a charm, all of them but I was looking more for Maqbool's solution. so double thanks.
Is there a way to make the same in Access? to be presented in a report?
-->tt
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