Counting dates in filtered column

[curleyy]

Hi all,

I'm trying to count the number of cells that contain a date in
filtered column. I've been using the following formula, but it keep
coming back with a value of 0, even though there are 3 in the filtere
row;

=SUMPRODUCT(--('Fixtur
Status'!J3:J1000=">=0"),SUBTOTAL(3,OFFSET('Fixtur
Status'!J3,ROW('Fixture Status'!J3:J1000)-ROW('Fixture Status'!J3),0)))

Any suggestions as to where I'm going wrong?

 

[Ron Rosenfeld]

Hi all,

I'm trying to count the number of cells that contain a date in a
filtered column. I've been using the following formula, but it keeps
coming back with a value of 0, even though there are 3 in the filtered
row;

=SUMPRODUCT(--('Fixture
Status'!J3:J1000=">=0"),SUBTOTAL(3,OFFSET('Fixture
Status'!J3,ROW('Fixture Status'!J3:J1000)-ROW('Fixture Status'!J3),0)))

Any suggestions as to where I'm going wrong??

why not just use the Subtotal(Count .... function?

=subtotal(2,'Fixture Status'!J3:J1000)