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...
packie Both formulas return 0 for me if there's noting to count or sum. I suspect that you have a custom format (like General;General;) that suppresses zeros. Set the cell format to General and you should get zeros back.