Hello,
I am trying to count how many times a value appears between a given date range.
So if I have 2 columns (A & B):
A
1/1/13
1/3/13
1/8/13
1/10/13
1/13/13
2/2/13
B
yes
yes
no
no
no
yes
I want to know how many times "no" came up between 1/1/2013 & 2/1/2013. I tried to use an IF statement which returns the correct value but it does not look in the other column to give me my results. Help! This seems like a simple LOOKUP formula but I cannot figure out how to do this. Using Excel 2003.
Thank you!
Bookmarks