# Amend formula to include numerous criteria

Occasional Contributor

# 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.

0 Replies