SUM Value error

You divide by the contents of column B. On row 5, this is zero ( 0 ). To cater for that, you can use IFERROR. For example:

Formula:

Please Login or Register  to view this content.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Welcome to the Forum simransonu08!

First, it is almost always better to attach your actual Excel file instead of a screenshot. Please see the yellow banner at the top of the page.

Mathematics says that division by 0 is undefined, so Excel can't do it either. The error you get is because B5 is 0. To fix this, update your formula:

Formula:

Please Login or Register  to view this content.

This will leave the result blank if the Count is 0.

You're welcome.



If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

Another question if you have time to answer. You may refuse to help.

May I send you the excel data that I maintain that i use for sending out the weekly/monthly stats to the team. The application used at my company does not really provide an accurate average report. So I manually dump data into my Excel to calculate the average. We don't assign metrics to agents but I like to share the data with them.
Report 7.17-7.21 and 7.24-7.29 is the raw data downloaded from our application.
July WK4TEST is my excel

Another question if you have time to answer. You may refuse to help.

Yes, it IS another question. Please mark THIS thread as solved and start a new thread with the new question. This is NOT a refusal to help.


If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.