If you want to return a blank in the AO column for those rows that have no data in them, then you could use a function on column AO. In the example below the 'if' function checks to see if cells A3, B3...G3 is blank (in this case these are the range that could contain data, yours may be dif.). If all the range is blank then a blank entry (" ") will show in the AO cell that refers to that row, otherwise the range A3:G3 is added together and is shown in that cell, regardless if the value =0 or not it will show.

=IF(AND(ISBLANK(A3),ISBLANK(B3),ISBLANK(C3),ISBLAN K(D3),ISBLANK(E3),ISBLANK(F3),ISBLANK(G3)),"",SUM( A3:G3))

I hope this is what you were asking

P.s. you could also use a filter to show only the non blank rows using either a filter or creating a list.

Garry