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.....
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
More Count Help please....
- Thread starter devans
- Start date
Brian from Maui
MrExcel MVP
- Joined
- Feb 16, 2002
- Messages
- 8,459
just_jon said:Why is it I NEVER remember ISNUMBER/MATCH, Brian? Am insideous internal desire to get a spanking from Aladin or youYou'd think I'd remember by now...
It took me a while too!
Upvote
0
Excel Facts
Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Similar threads
- Solved
