Round formula

[GIDRA]

I have this formula (below). Is there an easier way to do it ?
=ROUND(D53,3)+ROUND(E53,3)+ROUND(F53,3)+ROUND(G53,3)+ROUND(H53,3)+ROUND(I53,3)+ROUND(J53,3)+ROUND(K53,3)+ROUND(L53,3)+ROUND(M53,3)+ROUND(N53,3)

Thanks.

 

[Jarek Kujawa]

1. =SUMPRODUCT(ROUND(D53:N53,3))
ENTER it

2. =SUM(ROUND(D53:N53,3))
this is an array-formula so CTRL+SHIFT+ENTER it

 

[Jarek Kujawa]

1. =SUMPRODUCT(ROUND(D53:N53,3))
ENTER it

2. =SUM(ROUND(D53:N53,3))
this is an array-formula so CTRL+SHIFT+ENTER it

 

[Jacob Skaria]

=SUMPRODUCT((ROUND(D53:N53,3)))

If this post helps click Yes

 

[Jacob Skaria]

=SUMPRODUCT((ROUND(D53:N53,3)))

If this post helps click Yes

 

[Tony7659]

Also,

=ROUND(SUM(D53:N53),3)

No need to Ctrl-Shift-Enter it.

Tony.

(Click "Yes" if helpful to you)

 

[Tony7659]

Also,

=ROUND(SUM(D53:N53),3)

No need to Ctrl-Shift-Enter it.

Tony.

(Click "Yes" if helpful to you)