Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1352465%22%20slang%3D%22en-US%22%3EExcel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1352465%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20using%20the%20SUMIF%20function%20how%20can%20I%20get%20the%20answer%20to%20show%20in%20the%20cell%20as%20blank%20if%20the%20sum%20is%200%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1352465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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

1 Reply
Highlighted

@3Mungo Perhaps

=IF( SUMIFS(), SUMIFS(), "")

or

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