#DIV/0! Errors?

you could use an if construct to check either if there is 0 or "" or if there is an error, for example:
=IF(ISERROR(C1/B1),"",C1/B1)
or
=IF(OR(B1="",B1=0),"",C1/B1)

Thank you for your reply, please forgive me I am quite new to this. So do I place either one of these formulas in column d because I have just entered the first one suggested and it now since the change it just shows 0.00 in the column regardless of what is typed in columns b or d - Or do I still need to have the original formula inline too? What should I type into column d?

Only issue I have now is the column D should average out the totals so what formula would I need to put in there please? it is currently -
=AVERAGE(D7:D12)

The two formulas are just different ways of acheiving what you want, one evaluates the equation to see if returns an error, one checks that the input to the equation is valid.

I don't know what your table looks like so can't really comment on the average. I would assume that =average(D7:D12) would be correct, if D7:D12 is the cells you want to average.

Yes and all in between but that total is giving the same error when all other cells are empty I just need to ignore 0's again in the total and I will be done

Sorry, I don't understand. Please can you upload a sample of your workbook so I can see what is happening. If you press "go advanced" and then "attachments" you can attach a workbook to your reply.

Originally Posted by yudlugar

Sorry, I don't understand. Please can you upload a sample of your workbook so I can see what is happening. If you press "go advanced" and then "attachments" you can attach a workbook to your reply.

I hope you can see this? The sales and profits add up fine now and with the formula you kindly provided it all works but the total average where the arrows are show errors.

Hi - please upload the actual workbook, not a screenshot

Can I email it to you rather than upload it onto the public forum?

Just upload the part that we are talking about, get rid of any information which doesn't affect it and replace any sensitive data with dummy data

Okay here you go

okay, try:
=IF(ISERROR(AVERAGE(D7:D12)),"",AVERAGE(D7:D12))

Originally Posted by yudlugar

okay, try:
=IF(ISERROR(AVERAGE(D7:D12)),"",AVERAGE(D7:D12))

You are a star! Thanks you soooo much