Count If Statement
The attached spreadsheet I believe does what you want to do. Your biggest problem was using the quotes when defining the comparison cell. I removed the quotes and inserted some $ to help when you copy/paste the formula to minimize the amount of editing that will be needed.
Look at the formulas in the yellow shaded area for what I did.
Good luck.
|