COUNTIF with DATE

[Drewmyster]

Hi there,

I'll try and explain better than I did yesterday what it is I'm trying to achieve.

I'm trying to count the number of accounts which are enabled on any given date. Account statuses range from Enabled, Disabled, Expired or Deleted.

I have multiple sheets with data on them and a date range down column A on each of them. Account types range from Basic, Business and Flexi.

On the "Front" sheet I have a cell with the current date in it (B3).

I want to count how many occurances of the word "Enabled" is found against the date in the date range ('BASIC'!A:A), and that matches the date in cell B3. The account status is in column J.

Here is the formula I'm using which I need to adjust somewhat;

=COUNTIF('BASIC'!A:J,"Enabled")

This returns the count for the word "Enabled" accross all dates, not the date in cell B3 only.

Please advise.

 

[mikerickson]

Perhaps something like

=SUMPRODUCT(--(A1:A1000=B3),--(J1:J1000="Enabled"))