Countif, if, and a mind boggling excel sheet
All right, I am a slight novice at excel. I feel like I know a lot about it but the subject I'm trying to figure out is troubling me.
I have an excel worksheet that in collum a I will have dates. And collum be I will have a drop down box that will allow you to click yes or no. so what I want is to be able to somehow show how many times someone says yes in a certain month.
Ex: in collumn a I have 3 months worth of dates (november, January, February,i.e. 1/1/08,with some dates missing ). Then in collumn be I have a few yes's and 8 no's. And I want to be able to show in another part of the sheet how many times someone says yes in the month of January. I have been looking around the internet at nested ifs and arrays but I can't completely figure out how to use them in my cercumstances. As of right now I have my spreadsheet split up and just am using countif command and having the range a dedicated range (b2-b80) for one month then b81-b100) for a nother. I was wondering if there was a way so that if I put any date in any place on collumn A it would recognize it and know to add that date if it was a yes