EXCEL1: If is number and Sum formula

[aacod]

I want a sum formula in cell I13, such that if there is a number in cell B13, D13,F13,H13, put total of B13, D13, F13, H13 in I13 or leave it blank.

Thanks.

 

[aacod]

P45cal,

Changing your original formula

=IF(COUNT(B13,D13,F13,H13)=4,SUM(B13,D13,F13,H13),"")

to =0 or completely removing =4, both work PERFECT.

With combination of your formula

=IF(COUNT(B13,D13,F13,H13),SUM(B13,D13,F13,H13),"")

and Rick's formula,

=IF(COUNT(B7:B12),SUM(B7:B12),"")

I could achieve my results PERFECTLY. Thank you all.

aacod.

 

[aacod]

Rick,

Please see thread #10 & 11.

Thanks,

aacod