S
samprince
=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.
=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.