Amend formula to include numerous criteria

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.