Hey Everyone, Here's my issue:
I am trying to get my excel sheet to get rid of the #NUM! error in my cell and replace it with a "0" or "-" symbol for cells where no data is going to be entered, my formula that I am currently using to determine my average volumes for a specific year works great!! just looking to clean up the excel sheet a little. Attached is a small sample of what I am working with.
Thank you all who take a look at this!!