Hi,

First off, just to let you guys know, I am using Excel 2003.

My problem involves, what I believe should be the COUNTIF function. Essentially, I want to use to count based on two "ifs". In other words, I want to count the number of "1"s in column C, as long as it also has a "1" in column A. I want to proceed by doing the number of "1"s in column C, with a "2" in column B, and etc.

I was thinking of using 2 COUNTIF's, but I do not believe that is the way to go. I also tried using an IF and a COUNTIF, but that did not seem to work either.

The second question I have is how to make the window inside the window. I remember briefly seeing one, but what I mean is cutting a table off from the rest of the spread sheet so that it has its own separate scroll bars.

Thank you very much for your help.