Hi everyone,
As you might have noticed this is my first post here and I feel rather ashamed that it is about an often asked topic. But here it goes:
I have a number of very large data files (minimum 10000k rows). I would like to count the number of people that fit various criteria. I have already done something about it but need to add another criterion and I am kindda stuck. I cannot install any outside programs since I do not have admin privileges to the computer I am working with.
Here is the formula that I am currently using:
=COUNT(AZ10702:AZ21190)-COUNTIF(AZ10702:AZ21190,"<1")-COUNTIF(AZ10702:AZ21190,">10")
I have 10 more equations like this.
Now the problem is that I have another variable in column AF and I would like to only count the rows where AF = 3. How can I add this to my current setup? I was desperate enough to delete all rows where AF did not equal 3 but I have 27 data files and it is going to take too long.
Any suggestions would be much appreciated!
I should note that I am stuck to using an older version of excel at work either 2002 or 2003.
Bookmarks