Forum Discussion
Display result as a zero instead of a blank cell
Hi, When the following formula have nothing to return a blank cell displays. COUNTIFS(Trades!$R$5:$R$1099,D37,Trades!$O$5:$O$1099,">0") SUMIFS(Trades!$O$5:$O$1099, Trades!$R$5:$R$1099, D...
You are correct. The sheet Trades has the cell format set to General;General;
I will want to keep the format General;General; though, is there a work around I could use?
I will want to keep the format General;General; though, is there a work around I could use?
The format General;General; explicitly suppresses 0 values because the 3rd section (after the 2nd semicolon) is empty.
I'd use General, as suggested by Riny_van_Eekelen but if you really want to, you could use General;General;General or General;General;0