Counting number of rows where datediff of two columns meet criteria

[rmillman]

I have a range of data and need to summarize some of the data. In the table below is an example of the data. I would like to have a single formula where I can count the number of rows where the end date - start date is < 14 days. I would prefer not to add an additional column for the datediff value. Is there a way to do this with either arrays or named ranges?

Name	Start	End	Other data
Verizon	1/10/2010	1/25/2010
AT&T	3/2/2010	4/14/2010

<tbody>
</tbody>

 

[davesweep]

Hi,

Assuming that your data starts in A1,

=SUMPRODUCT(((C2:C8-B2:B8)<14)*(1))

or

=SUMPRODUCT(((C2:C8-B2:B8)<14)*((C2:C8-B2:B8)<>0)*(1))

to exlude rows where the difference is zero