COUNTIF statement - how can i use multiple args/ criteria
Posted by Daniel Cremin on February 05, 2002 5:55 AM
Hi ive already solved this requirement to be able to find out how many members of each separate class (different names in teacher cell class) are achieving each poss grade through a filtering macro that gets them to another page where there is a countif statement waiting in the wings. However just for general interest id like to know if i can somehow get Excel to only count grade A (this is the if argument, for studenta in a certain class (e.g. Mr Cremin group)- the prob is that the cells arent re-sorted by teacher name so i cant simply have countifs for pre-specified cells all with grades of students from specific classes - the idea of the project is that students can be entered at ne time.