Forum Discussion

Estel333's avatar
Estel333
Copper Contributor
Mar 14, 2023

Amend formula to look for entries on one date only

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 😧 =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.

 

Regards.

No RepliesBe the first to reply

Resources