Hide total cell value when the amounts are empty in #excel #exceltricks

while totalling the amount fields, If the data is not available at the amount columns. Then the total sum value should be emptied instead of showing as 0.0
To achieve we have provided a technique through Custom Format available in format menu.

This technique works in Google Spreadsheet.

#excel #googlespreadsheet #shorts #exceltricks #amount #sum