Amend formula to look for entries on one date only

Occasional Contributor

Amend formula to look for entries on one date only




How can the below formulas be combined to return criteria for a specific date only AND stay static?


SIC Columns.JPG


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  =IFERROR(COUNTIF('Daily Management Tool'!$M$2:$M$30001, "Referred to Broker"),"")


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.



0 Replies