Waht formula i should use

[Guest]

I have 3 excel sheets, CBL 1 and CBL 2, and the last is Total CBL.
What I want to do is sum de same cell of CBL1 and CBL2 (for example D12) in
the TOTAL CBL, teh resul shoul appear on the D12 cell on the Total CBL sheet.
The problem is if the value is equals to zero, i dont want to see any
result, I want to have a blank cell.

 

[Govind]

Hi,

Use

=IF(SUM(CBL 1:CBL 2!D12)=0,"",SUM(CBL 1:CBL 2!D12))

Regards

Govind

 

[Max]

One way is to suppress extraneous zeros from displaying
in the TOTAL CBL sheet via:
Tools > Options > View tab > Uncheck Zero values > OK

 

[Guest]

Thank you very much

you have solved my problem, in a very simple way

"Max" escreveu:

 

[Guest]

Thank you very much

you have solved my problem

"Govind" escreveu:

 

[Max]

You're welcome, Filipe !
Thanks for posting back

 

[Govind]

Hi,

Thanks for the feedback.

Regards

Govind.

Thank you very much

you have solved my problem

"Govind" escreveu: