Amend formula to look for entries on one date only
Hi,
How can the below formulas be combined to return criteria for a specific date only AND stay static?
How the formulas should work are as follows:
1. The date and timestamp in column A is recorded whenever the user captures a number in column J
2. The formulas in columns C, D, E, F, G, H, L, and O should return the criteria but ONLY for the same date (not time) as in column A
The formulas in the above columns are:
Column C: =SUM(COUNTIFS('Daily Management Tool'!$M$2:$M$30001,{"Transferred to Pom","Transferred to Sales","Transferred to Voice","Transferred to Other Centre"}))
Column
Column E: =SUM(COUNTIFS('Daily Management Tool'!$M$2:$M$30001,{"Referred to FLM","Referred to 2IC","Referred to COE","Referred to TM","Referred to CU via COE","Referred to RM","Referred to TQA","Referred to BLO"}))
Column F: =IFERROR(COUNTIF('Daily Management Tool'!$M$2:$M$30001, "Logged with IT"),"")
Column G: =IFERROR(COUNTIF('Daily Management Tool'!$K$2:$K$30001, "1"),"")
Column H: =COUNTA(UNIQUE('Daily Management Tool'!E2:E10001))-1
Column L: =IFERROR(SUM('Daily Management Tool'!$I$2:$I$30001),"")
Column O: =IFERROR(SUM('Daily Management Tool'!$I$2:$I$30001),"")
Any assistance will be appreciated.
Regards.