sir need to know no of cells on particular and particular status

[lathish]

sir need to know one particular day three types of sales like closed,deliver,cancelled in huge sheet
[TABLE="width: 243"]
<colgroup><col span="3"></colgroup><tbody>[TR]
[TD]date[/TD]
[TD]name [/TD]
[TD]status[/TD]
[/TR]
[TR]
[TD]29 /1/2018[/TD]
[TD]Nancy[/TD]
[TD]delivered[/TD]
[/TR]
[TR]
[TD]29 /1/2018[/TD]
[TD]Makbool[/TD]
[TD]delivered[/TD]
[/TR]
[TR]
[TD]29 /1/2018[/TD]
[TD]VARADARAYA[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]29 /1/2018[/TD]
[TD]Pradhyum[/TD]
[TD]cancelled[/TD]
[/TR]
[TR]
[TD]29 /1/2018[/TD]
[TD]A[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]29 /1/2018[/TD]
[TD]KISHORE KUMAR UBRANGALA[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]28 /1/2018[/TD]
[TD]K Prakash[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]28 /1/2018[/TD]
[TD]N VISWANATHAN[/TD]
[TD]Cancelled[/TD]
[/TR]
[TR]
[TD]28 /1/2018[/TD]
[TD]K Prakash[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]28 /1/2018[/TD]
[TD]Prakash[/TD]
[TD]Cancelled[/TD]
[/TR]
[TR]
[TD]28 /1/2018[/TD]
[TD]Wasim[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]ragul[/TD]
[TD]Cancelled[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]BHUVANESHWARI[/TD]
[TD]Cancelled[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]BHUVANESHWARI[/TD]
[TD]Cancelled[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]Manu[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]BHASKAR[/TD]
[TD]Cancelled[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]ragul[/TD]
[TD]Cancelled[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]ARULMOLI[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]MAHESH[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]SRINIVASAN A[/TD]
[TD]Closed[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]Dr Gopalakrishna[/TD]
[TD]Closed[/TD]
[/TR]
</tbody>[/TABLE]

and result should come in this format
[TABLE="width: 324"]
<colgroup><col span="4"></colgroup><tbody>[TR]
[TD]date[/TD]
[TD]cancelled[/TD]
[TD]delivered[/TD]
[TD]closed[/TD]
[/TR]
[TR]
[TD]29 /1/2018[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]28 /1/2018[/TD]
[TD]2[/TD]
[TD]0[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]27 /1/2018[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD]3

[/TD]
[/TR]
</tbody>[/TABLE]

this is just example i need to clear huge sheet
kindly let me know if possible

 

[footoo]

Look up the COUNTIFS function.

 

[lathish]

Look up the COUNTIFS function.

sir kindly let me know the exact formula actually i have tried but failed lots of time

 

[footoo]

A Pivot Table would probably be better :
https://www.google.com.hk/search?q=...9i65l2j0l3.16092j0j8&sourceid=chrome&ie=UTF-8

 

[footoo]

If you don’t want to use a pivot table :
- Copy column A and paste to column E
- Remove duplicates from column E (Data/Data Tools)
- Enter Cancelled in F1, Delivered in G1, Closed in H1
- Enter in F2 =COUNTIFS($A:$A,$E2,$C:$C,F$1) and drag down and across

A macro based on these steps :

Sub Summary()
[E:H].ClearContents
[A:A].Copy [E:E]
[E:E].RemoveDuplicates Columns:=1, Header:=xlYes
[F1] = "Cancelled"
[G1] = "Delivered"
[H1] = "Closed"
Range([F2], Cells(Rows.Count, "E").End(xlUp)(1, 4)) _
    .Formula = "=COUNTIFS($A:$A,$E2,$C:$C,F$1)"
[E:H].Columns.AutoFit
End Sub

 

[lathish]

Thank you very very much soo helpful thanks