# Excel

Highlighted
Occasional Visitor

# Excel

When using the SUMIF function how can I get the answer to show in the cell as blank if the sum is 0?

``=IF( SUMIFS(), SUMIFS(), "")``
``=IFERROR( 1/1/SUMIFS(), "")``