Simple =Sum ?

[zone709]

=SUM(H2+K2+N2)-(R2:AF2)

Hi I can get this to work. Sometimes the cell in N is blank so it will return #value . Plus I want to - the range (r2 to Af2)

Any better way for this to work thanks

 

[Ron Coderre]

Maybe this:

=SUM(H2,K2,N2)-SUM(R2:AF2)

Does that help?

 

[Dave Patton]

consider

=SUM(H2,K2,N2)-SUM(R2:AF2)

or

=H2+K2+N2-SUM(R2:AF2)

 

[zone709]

Boom thank you. Kept getting #value cause some cells sometimes have blanks thanks again.

 

[sandy666]

or =SUM(H2,K2,N2,-R2:AF2) with CSE