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
|
.formula copy cell reference in range excel vba clear Count of different values in 2 rows in excel Excel "if then formula" "contains specific text" then Excel cell compare with if condition Excel formula count if two different values Excel formula for finding & remove repeated words in a column Excel formula if a = b then place x into y Excel formula to count how many a certain value is Excel formula to determine if number is positive or negative Excel formula to sum and sub in one column Excel formulas calculate sum if between two dates Excel how count repeated cells in a column Excel list of data copied on column if Formula to determine if cell contains word excel If false keep formula excel Ms excel with 10 formula Suggest excel formula to counting colour highlighted data Vba excel formula and comma