Having problems using the Count function in Excel

  • Thread starter Thread starter lj
  • Start date Start date
L

lj

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)))}
 
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.
 
Back
Top