View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
via135
 
Posts: n/a
Default offsetting values of multiple cells!


hi!

i am having a list of values thru A1:A10
as under:


10.1
3.2
1.4
2.0
4.0
5.5
3.0
0.5
1.1
0.5

what i want is to retain the rows A4 and A9 alone, after offsetting

A2+A3+A6 against A1 (10.1)

and

A7+A8+A10 against A5 (4.0)


hlp pl?

-via135


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=548681