<div>
You need something like.....<br />
<br />
=countif(A1:A20,&quot;&gt;&quot;&amp;B1)<br />
<br />
That assumes your column A has date values in cells A1 through A20 that you want to check against and that your cell B1 has the date you want to compare with<br />

</div>


You need something like.....

=countif(A1:A20,">"&B1)

That assumes your column A has date values in cells A1 through A20 that you want to check against and that your cell B1 has the date you want to compare with


<div>
You can't do that very easily with COUNTIFS - try SUMPRODUCT, i.e.<br />
<br />
=SUMPRODUCT((Date_Due_To_H<wbr />Q&gt;Sent_By_<wbr />Tertiary)+<wbr />0)<br />
<br />
regards, barry
</div>


You can't do that very easily with COUNTIFS - try SUMPRODUCT, i.e.

=SUMPRODUCT((Date_Due_To_HQ>Sent_By_Tertiary)+0)

regards, barry

<div>
Neither gave me the solution... What I am trying to do is compare the sent date to the date due to determine if they are late, and if its late I want to count them. &nbsp;The due date is variable in each row. 
</div>


Neither gave me the solution... What I am trying to do is compare the sent date to the date due to determine if they are late, and if its late I want to count them.  The due date is variable in each row.

<div>
Then add a column? =if(Date_Due_To_HQ&gt;Sent_By<wbr />_Tertiary,<wbr />1,0)<br />
And at the bottom of it do a sum!
</div>


Then add a column? =if(Date_Due_To_HQ>Sent_By_Tertiary,1,0)
And at the bottom of it do a sum!

27242060.xlsx

<div>
<div class="content wysiwyg-content">
I am trying to count the number of dates that are greater than the corresponding date in the same row. I tried a COUNTIF but it is just looking if the date is great than any of the dates, so its not working. Here is the formula: =COUNTIFS( Date_Due_To_HQ,&quot;&gt;&quot;&amp; Sent_By_Tertiary)<br />
<br />
So if the date in Date_Due_To_HQ is greater than the corresponding date in Sent_By-Tertiary then I want it counted. Any help would be much appreciated!
</div>
</div>


I am trying to count the number of dates that are greater than the corresponding date in the same row. I tried a COUNTIF but it is just looking if the date is great than any of the dates, so its not working. Here is the formula: =COUNTIFS( Date_Due_To_HQ,">"& Sent_By_Tertiary)

So if the date in Date_Due_To_HQ is greater than the corresponding date in Sent_By-Tertiary then I want it counted. Any help would be much appreciated!

COUNTIFs from two columns

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.