Hello,
I am trying to write a formula to count only certain dates of events in colum A but only IF column F meets certain criteria. I have a formula to count the differenence already in column A for another number I need, but I'm having difficulty adding to the formula to meet the 3rd critera.
This is my working formula to count events from the beginning of the year to today's date (Cell D2 is a formula for today's date):
=COUNTIF(A5:A106,"<=" & +D2)-COUNTIF(A5:A106,"<" & DATE(2009,1,1))
Now I need to make it count these same events only if they have "AM" in column F.
Here's what I have been trying with no luck...
=COUNT(IF(A5:A106,"<="&+D2)-IF(A5:A106,"<"&DATE(2009,1,1))-COUNTIF(F5:F106,"AM"))
Please Help!
Configuration: Windows XP Internet Explorer 7.0
Try this
|
Average day calculation excel formula Convert numeric to alphabate in excel formula Excel 2007 conditional formatting if value of other cell Excel formula add collumn negative value Excel formula check if value exist in cell Excel formula count if several columns Excel formula countif column a=x and columnb=y Excel formula for making field coloured if value is greater Excel formula if negative Excel formula if then copy Excel formula percentage increase Excel formula return value into another function Excel formula sum range if cell equals value Excel formula to check if 2 cells are equal Excel macro programming examples if string then count If value not in column excel formula Percentage excel formula What is the excel formula to show the word