=INDIRECT("B"&(ROW($G$2)+6+(ROW(F2)-2)*7))
=INDIRECT("B"&(ROW($G$2)+(ROW(G2)-2)*7))
=INDIRECT("B"&(ROW($G$2)+1+(ROW(H2)-2)*7))
=INDIRECT("B"&(ROW($G$2)+2+(ROW(I2)-2)*7))
=INDIRECT("B"&(ROW($G$2)+3+(ROW(J2)-2)*7))
=INDIRECT("B"&(ROW($G$2)+4+(ROW(K2)-2)*7))
=INDIRECT("B"&(ROW($G$2)+5+(ROW(L2)-2)*7))

Atm I am using the above to list take all data from column B in Day
order andlist into a new row giving weekly totals.

I can manipulate this formula to take data from different columns.

However, if I dont understands what the following sections of the
forumula relate to and what/how I can chagne them to my advantage. i.e
fortnightly lists, monthly lists etc etc.

&(ROW($G$2)+3+(ROW(J2)-2)*7))

^^^ all of the above i do not understand anyone able to advise?

Thanks
SP.


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=553219