Hello,
I have two column lists (one value in each cell) the first { 1 2 3 1 2 2 2 1 1 1 } and the second {A B C C C B B A A C } and I am attempting to find out how to auto count two criteria such as... if the first column is 1 and the second column is A then count. i.e for this example the answer would be..3.
Help?
Thanks
Configuration: Windows XP Internet Explorer 6.0