Amend formula to include numerous criteria

Copper Contributor

Amend formula to include numerous criteria

 

Hi,

 

How can the below formulas be amended to add more criteria?

 

Column L to have 4 x criteria: =IFERROR(SUM('Daily Management Tool'!$I$2:$I$30001),"")

 

How can I amend the formula in column L to:

 

1.1 SUM the hh:mm in 'Daily Management Tool'!$I$2:$I$30001; AND

 

1.2 Only SUM entries for which this range 'Daily Management Tool'!$M$2:$M$30001 contains only text "Closed"; AND

 

1.3 Look only for entries on the same date (not time) that will be recorded in "SIC"!A2 (format in A2 is dd/mm/yyyy hh:mm) in this range 'Daily Management Tool'!$F$2:$F$30001; AND

 

1.4 SUM only unique values in this range 'Daily Management Tool'!$E$2:$E$30001 for the date that is recorded in 'SIC'!A 

 

Column O to have 4 x criteria: =IFERROR(SUM('Daily Management Tool'!$I$2:$I$30001),"")

 

How can I amend the formula in column O to:

 

How can I amend the formula in column L to:

 

2.1 SUM the hh:mm in 'Daily Management Tool'!$I$2:$I$30001; AND

 

2.2 Only SUM entries for which this range 'Daily Management Tool'!$M$2:$M$30001 contains ANY text; AND

 

2.3 Look only for entries on the same date (not time) that will be recorded in "SIC"!A2 (format in A2 is dd/mm/yyyy hh:mm) in this range 'Daily Management Tool'!$F$2:$F$30001; AND

 

2.4 SUM only unique values in this range 'Daily Management Tool'!$E$2:$E$30001 for the date that is recorded in 'SIC'!A

 

Any assistance will be appreciated.

 

Regards.

 

SIC Columns.JPGDMT Columns.JPG

0 Replies