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.
