Formula Syntax help

[ddub25]

When I try to adapt this formula:

=IF(X1465<>"",SUBTOTAL(9,T1465)+N(AN1464),AN1464)

to this:

=IF(X1465<>"",SUBTOTAL(9,(T1465+U1465))+N(AN1464),AN1464)

the formula is rejected because of incorrect syntax I think. Can anyone help with the correct syntax? Thanks.

Dan

 

[texasalynn]

does this work?
=IF(X1465<>"",SUBTOTAL(9,T1465,U1465)+N(AN1464),AN1464)

 

[ddub25]

Thanks, yes that does the job.

Dan