Having problems using the Count function in Excel

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)))}

One way:

=COUNTIF($A$8:$A$1000,"<="&F$24) - COUNTIF($A$8:$A$1000,">"&E$24)

lj@spu.edu wrote:
>
> 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)))}

--

Dave Peterson

This doesn't quite answer my question though, I'm trying to count the
non blank values in D, that are in the same row as A, where column A
meets the two conditions set in my formula.

Oopsie.

Try:

=SUMPRODUCT(--($A$8:$A$1000<=F$24),--($A$8:$A$1000>E$24),--($D$8:$D$1000<>""))

=Sumproduct() likes to work with numbers. The -- converts trues and falses to
+1's and 0's.



lj@spu.edu wrote:
>
> This doesn't quite answer my question though, I'm trying to count the
> non blank values in D, that are in the same row as A, where column A
> meets the two conditions set in my formula.

--

Dave Peterson

This is exactly what i need, thanks!!