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

[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl65, width: 71"]Customer Id[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Msisdn[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Created By Contact[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Ldesc[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD="class: xl65, width: 90"]Creation Date[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="class: xl65, width: 445"]reasson[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]Repeated[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl65, width: 71"]21478289[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]770400012[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]***[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]CALLCENTER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD="class: xl65, width: 90"]17-Nov-2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="width: 445, align: left"]Servicesbundledata bundle[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Formula here[/TD]
[/TR]
[TR]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl65, width: 71"]22263154[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]770400336[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]***[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]CALLCENTER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD="class: xl65, width: 90"]08-Nov-2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="width: 445, align: left"]Can not connect to internet Web (browsing issue )Web (browsing issue )[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="width: 445, align: left"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Formula here[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl65, width: 71"]22622727[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]770419450[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]***[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]CALLCENTER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD="class: xl65, width: 90"]30-Nov-2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="width: 445, align: left"]Offers & TariffsCorporateprecorp[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="width: 445, align: left"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Formula here[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl65, width: 71"]22416159[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]770480325[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]***[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl65, width: 64"]CALLCENTER[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 90"]
<tbody>[TR]
[TD="class: xl65, width: 90"]03-Nov-2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="width: 445, align: left"]Activation issuesmergingmerging[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="width: 445, align: left"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Formula here[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 71"]
<tbody>[TR]
[TD="class: xl65, width: 71"]22416159
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]770480325[/TD]
[TD]***[/TD]
[TD]CALLCENTER[/TD]
[TD]03-Nov-2016[/TD]
[TD]Activation issuesmergingmerging[/TD]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 445"]
<tbody>[TR]
[TD="width: 445, align: left"][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]Formula here[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

​

****** 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?