Hi,
I am a bit stuck here.
Below is an example of what I am working on. So for each month I have the number of Work Orders and the total labour hours.
At the end I want to show the average Labour Hours per Work Order.
That's simple: =SUM(B3,D3,F3,H3,J3,L3,N3,P3,R3,T3,V3,X3)/SUM(A3,C3,E3,G3,I3,K3,M3,O3,Q3,S3,U3,W3)
But if there are only zeros then naturally it will give back an error (#DIV/0!)
Can someone tell me how I can incorporate an IFERROR or IFISERROR into the above formula so it will show all errors as a 0?
[TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 1681"]
[tr][td][/td][td]A
[/td][td]B
[/td][td]C
[/td][td]D
[/td][td]E
[/td][td]F
[/td][td]G
[/td][td]H
[/td][td]I
[/td][td]J
[/td][td]K
[/td][td]L
[/td][td]M
[/td][td]N
[/td][td]O
[/td][td]P
[/td][td]Q
[/td][td]R
[/td][td]S
[/td][td]T
[/td][td]U
[/td][td]V
[/td][td]W
[/td][td]X
[/td][td]Y
[/td][/tr][tr][td]1
[/td]
[TD="colspan: 2"]Apr-18[/TD]
[TD="colspan: 2"]May-18[/TD]
[TD="colspan: 2"]Jun-18[/TD]
[TD="colspan: 2"]Jul-18[/TD]
[TD="colspan: 2"]Aug-18[/TD]
[TD="colspan: 2"]Sep-18[/TD]
[TD="colspan: 2"]Oct-18[/TD]
[TD="colspan: 2"]Nov-18[/TD]
[TD="colspan: 2"]Dec-18[/TD]
[TD="colspan: 2"]Jan-19[/TD]
[TD="colspan: 2"]Feb-19[/TD]
[TD="colspan: 2"]Mar-19[/TD]
2
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]No of WO
[/td][td]Lab Hrs
[/td][td]Lab Hrs/WO
[/td][/tr][tr][td]3
[/td][td]0
[/td][td]0
[/td][td]0
[/td][td]0
[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]#DIV/0
[/td][/tr]
[/TABLE]