ExcelBanter - Return cell blank ifsum=0

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Return cell blank ifsum=0 (https://www.excelbanter.com/excel-discussion-misc-queries/152739-return-cell-blank-ifsum%3D0.html)

Mark Allen

Return cell blank ifsum=0

I am using this formula

=SUMIF(F:G,L29,G:G)

normal answer is for instance 33456
sometime the answer is 0
When the answer is 0 I want the cell to show nothing at all

Is this possible ???

Regards

Mark

Return cell blank ifsum=0

try
=if(SUMIF(F:G,L29,G:G)=0,"",SUMIF(F:G,L29,G:G))

"Mark Allen" wrote:

I am using this formula

=SUMIF(F:G,L29,G:G)

normal answer is for instance 33456
sometime the answer is 0
When the answer is 0 I want the cell to show nothing at all

Is this possible ???

Regards

Mark

All times are GMT +1. The time now is 09:03 AM.