Create a formula add value result from multiple cells

[Brew]

how do I create a formula the will count & add the total result from:
D6 in sheet1 of the trending3a file within the progressive folder on the e-drive
with
D6 in sheet1 of the trending3b file within the progressive folder on the e-drive
to
the bankend file
If the result is 0, then the result is blank

 

[PaddyD]

What have you tried & what results have you got?

 

[Brew]

i kept playing with it, til I resolve the issue...ty..see below
=('E:\Progressive\[trending3a.xls]sheet1'!$d$6+'E:\Progressive\[trending3b.xls]sheet1'!$d$6)

 

[PaddyD]

"If the result is 0, then the result is blank"

...with long file names like that, i'd just stick the results in a cell & either use another formula for that bit:

=if(a1=0,"",a1)

...or set the tools | options | view - window options - zero values setting.

 

[Brew]

thank you for the update