exceluser9
Active Member
- Joined
- Jun 27, 2015
- Messages
- 388
Hi Team,
I have below data and require countif formula or any other formula to get the count. Require your support.
I require only the today's date count to be captured. Email Sent 1, Email Sent 2 and Email Sent 3 (All 3 column count should be in Emails sent 1;2;3.
Thanks
[TABLE="width: 586"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 6"]Sheet 1 (Expected result)[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Received date count[/TD]
[TD]Emails sent 1;2;3[/TD]
[TD]Queried answered[/TD]
[TD]Not required[/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]Peter_KU[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]James_BR[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]John_BL[/TD]
[TD]1[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 744"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 8"]Sheet 2 (Data)[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Received date[/TD]
[TD]Email Sent 1[/TD]
[TD]Email Sent 2[/TD]
[TD]Email Sent 3[/TD]
[TD]Queries[/TD]
[TD]Not required[/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]Peter_KU[/TD]
[TD]25/06/2019[/TD]
[TD]24/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]23/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[/TR]
[TR]
[TD]James_BR[/TD]
[TD] [/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John_BL[/TD]
[TD]23/05/2019[/TD]
[TD] [/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Peter_KU[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[/TR]
[TR]
[TD]James_BR[/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD] [/TD]
[TD]23/05/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John_BL[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Peter_KU[/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD] [/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]James_BR[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John_BL[/TD]
[TD]22/05/2019[/TD]
[TD]22/05/2019[/TD]
[TD]22/05/2019[/TD]
[TD]22/05/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
I have below data and require countif formula or any other formula to get the count. Require your support.
I require only the today's date count to be captured. Email Sent 1, Email Sent 2 and Email Sent 3 (All 3 column count should be in Emails sent 1;2;3.
Thanks
[TABLE="width: 586"]
<colgroup><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 6"]Sheet 1 (Expected result)[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Received date count[/TD]
[TD]Emails sent 1;2;3[/TD]
[TD]Queried answered[/TD]
[TD]Not required[/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]Peter_KU[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]James_BR[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]John_BL[/TD]
[TD]1[/TD]
[TD]6[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 744"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 8"]Sheet 2 (Data)[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Received date[/TD]
[TD]Email Sent 1[/TD]
[TD]Email Sent 2[/TD]
[TD]Email Sent 3[/TD]
[TD]Queries[/TD]
[TD]Not required[/TD]
[TD]Completed[/TD]
[/TR]
[TR]
[TD]Peter_KU[/TD]
[TD]25/06/2019[/TD]
[TD]24/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]23/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[/TR]
[TR]
[TD]James_BR[/TD]
[TD] [/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John_BL[/TD]
[TD]23/05/2019[/TD]
[TD] [/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Peter_KU[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[/TR]
[TR]
[TD]James_BR[/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD] [/TD]
[TD]23/05/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John_BL[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Peter_KU[/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD]23/05/2019[/TD]
[TD] [/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]James_BR[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]John_BL[/TD]
[TD]22/05/2019[/TD]
[TD]22/05/2019[/TD]
[TD]22/05/2019[/TD]
[TD]22/05/2019[/TD]
[TD]25/06/2019[/TD]
[TD]25/06/2019[/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]