Formula ???
Posted by Jack on August 23, 2001 3:08 PM
B2:B4 indirect Address
1.1 value
2 value
3 value
6 =SUM(ROUND(B2:B4,0))+N("TEST")CSE ARRAY
poss how can i round indirect ???? Excel not liking it?? any ideas please i would love to know, i use indirect for all SUMed calcs
Posted by Bob on August 23, 2001 7:33 PM
If you want to add the cells and then round the total :-
=ROUND(SUM(B2:B4),0)
If you want to round each cell and then sum the rounded values :-
=SUM((ROUND(C2:C4,0)))
