Forum home » Delegate support and help forum » Microsoft Excel Training and help » Adding IFERROR to formulas

Adding IFERROR to formulas

ResolvedVersion 2016

Fri 13 Jul 2018, 13:10 Delegate Sam said...

Sam has attended:
Excel Advanced course

Adding IFERROR to formulas

How would I add IFERROR to the below formula is coming out as #DIV/0! And I want it to show as 00:00:00

=SUMIFS('Weekly Numbers'!$L$6:$L$22,'Weekly Numbers'!$B$6:$B$22,"Install Netrefer pixel",'Weekly Numbers'!$G$6:$G$22,"Blocker")/C10

Thanks,

Sam

Fri 13 Jul 2018, 13:13 Trainer Jens said...

RE: adding IFERROR to formulas

Hi Sam,

Thank you for the forum question.

Please use formula below.

= IFERROR(SUMIFS('Weekly Numbers'!$L$6:$L$22,'Weekly Numbers'!$B$6:$B$22,"Install Netrefer pixel",'Weekly Numbers'!$G$6:$G$22,"Blocker")/C10,TIME(0,0,0))

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 20 Jul 2018: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly create a list of numbers

The fill handle in Excel has many uses. If a number is typed into a cell and then the fill handle is used, the number will be copied from one cell to the next.

If you wish to create a list of numbers that increment by one at a time, hold down Ctrl in conjunction with using the fill handle - this should give you a series of numbers (e.g. 1, 2, 3 etc) rather than copying a single number.

View all Excel hints and tips

Adding IFERROR to formulas

Adding IFERROR to formulas

RE: adding IFERROR to formulas

Excel articles

Excel tip:

Quickly create a list of numbers