ok. I am setting up a count statement based on two columns, column A has the words Filled or Open, column I has numbers. I want a formula that will say If column A says Filled AND Column I has the numbers 10 - 17, count. It's the Column A part of the formula that I'm struggling with. I can write the COUNTIF formula to count the number, but not how to relate it to what's in C. A.....