I have Excel 2010 and am trying to change a formula I have that is currently working. The formula that is working is:
=COUNTIFS($B$2:$B$13957,">=4/22/2011",$AD$2:$AD$13957,$AE$2)
What I want to change is a couple things. I want to count the entire columns of B and AD and I want to enter the date into its own column so that I don't have to retype the date for all 368 rows that are using this formula since the date is different for each row. So I did this:
=COUNTIFS($B$2:$B$1000000,">=AP2",$AD$2:$AD$1000000,$AE$2)
but it doesn't seem to recognize AP2 (which is where I put the date 4/22/11). I've tried putting the quotation marks just around the >= and that didn't work, and I tried taking them out all together and that didn't work either. It only seems to recognize the cell as a cell when it is in there by itself but that would only count records with a date equal to AP2 and not greater than. Any ideas??
=COUNTIFS($B$2:$B$13957,">=4/22/2011",$AD$2:$AD$13957,$AE$2)
What I want to change is a couple things. I want to count the entire columns of B and AD and I want to enter the date into its own column so that I don't have to retype the date for all 368 rows that are using this formula since the date is different for each row. So I did this:
=COUNTIFS($B$2:$B$1000000,">=AP2",$AD$2:$AD$1000000,$AE$2)
but it doesn't seem to recognize AP2 (which is where I put the date 4/22/11). I've tried putting the quotation marks just around the >= and that didn't work, and I tried taking them out all together and that didn't work either. It only seems to recognize the cell as a cell when it is in there by itself but that would only count records with a date equal to AP2 and not greater than. Any ideas??