Hi,
I am looking to calculate an efficiency percentage from the last 5 jobs worked
ie
150%
100%
-
-
150%
I am currently using the following formula
=IF(F16="","",SUM(J23:J27)/5)
But this assumes there is 5 entries, but as you can see from the example there is only 3 entries from the 5 available thus giving a false reading
Can I modify my formula to suit the available entries?
Many thanks
I am looking to calculate an efficiency percentage from the last 5 jobs worked
ie
150%
100%
-
-
150%
I am currently using the following formula
=IF(F16="","",SUM(J23:J27)/5)
But this assumes there is 5 entries, but as you can see from the example there is only 3 entries from the 5 available thus giving a false reading
Can I modify my formula to suit the available entries?
Many thanks