Hi



When I am trying to add the following column cells I am getting DIV/0 as some of these cells themselves have DIV/0 as there is no data results in some of them.........Please can anyone tell me how to show 0 instead of DIV/0

=SUM(M11+S11+Y11+AE11+AK11+AQ11+AW11+BC11)

Thank you

Assuming you've discovered the IFERROR function?

Hi
in your formula the SUM function is redundant
=M11+S11+Y11+AE11+AK11+AQ11+AW11+BC11 will also do the trick

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Yes, found IFERROR.......and thanks for the =SUM tip