help me pls :(

[mohanadt2000]

hello,

I'm pretty new to Excel. What I'm trying to do is count (repeated calls) the number of times a person calls within 3 days the criteria is same customer ID,same customer mobile,same date and same reason . I use the formula =COUNTIFS($B:$B,B2,$A:$A,A2,$F:$F,F2,E:E,">="&(E2-3),E:E,"<="&E2)) but for some reason it there is something wrong .


below is a sample for the table

Customer Id <tbody> </tbody>	Msisdn <tbody> </tbody>	Created By Contact <tbody> </tbody>	Ldesc <tbody> </tbody>	Creation Date <tbody> </tbody>	reasson <tbody> </tbody>	Repeated <tbody> </tbody>
21478289 <tbody> </tbody>	770400012 <tbody> </tbody>	*** <tbody> </tbody>	CALLCENTER <tbody> </tbody>	17-Nov-2016 <tbody> </tbody>	Servicesbundledata bundle <tbody> </tbody>	Formula here
22263154 <tbody> </tbody>	770400336 <tbody> </tbody>	*** <tbody> </tbody>	CALLCENTER <tbody> </tbody>	08-Nov-2016 <tbody> </tbody>	Can not connect to internet Web (browsing issue )Web (browsing issue ) <tbody> </tbody>	<tbody> </tbody> Formula here <tbody> </tbody>
22622727 <tbody> </tbody>	770419450 <tbody> </tbody>	*** <tbody> </tbody>	CALLCENTER <tbody> </tbody>	30-Nov-2016 <tbody> </tbody>	Offers & TariffsCorporateprecorp <tbody> </tbody>	<tbody> </tbody> Formula here <tbody> </tbody>
22416159 <tbody> </tbody>	770480325 <tbody> </tbody>	*** <tbody> </tbody>	CALLCENTER <tbody> </tbody>	03-Nov-2016 <tbody> </tbody>	Activation issuesmergingmerging <tbody> </tbody>	<tbody> </tbody> Formula here <tbody> </tbody>
22416159 <tbody> </tbody> <tbody> </tbody>	770480325	***	CALLCENTER	03-Nov-2016	Activation issuesmergingmerging	<tbody> </tbody> Formula here <tbody> </tbody>

<tbody>
</tbody>

​

****** id="cke_pastebin" style="position: absolute; top: 372px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

 

[Logit]

Sorry ... wrong post.

 

[Dave Patton]

Try creating a concise example say 8 rows that should yield results from your formula.
Use Excel's Formula Evaluate to review the formula. See Formulas | Formula Auditing Evaluate Formula

Are dates in the list within the criteria specified?

You stated "for some reason it there is something wrong "
What does this mean?