Hi, I'm having problems using the count function in excel, I have the
following formula which works to look up and sum cells in column D that
are on the same row as entries in column A, which meet a date criteria
set in cells f24 and E24. The problem is that I want to make a
separate formula that counts the number of entries that have occurred
in column D. However, when I try to change the Sum to a COUNT I do not
get the correct number of rows. Any suggestions? Thanks

{=SUM(IF(A$8:$A$1000<=F$24,IF($A$8:$A$1000>E$24, D$8:$D$1000)))}