T
timmerchline
Hello,
This is my first post. Thanks for all of your help in advance. I a
working with a multi-sheet workbook. I am creating a 'summary' page an
am creating a 'total' sold of a product with multiple options.
Formula is:
Cell E14 =SUM(CLOTH!G10:G21)
I want to drag this formula down through E20 and have each cell on m
'total' page read as follows:
E15 =SUM(CLOTH!G30:G41)
E16 =SUM(CLOTH!G50:G61)
E17 =SUM(CLOTH!G70:G81)
There is a gap between the cells needed to create the formula here. I
there a way to drag down a formula and have excel do the rest? I though
that maybe if I entered 2-3 of them initially and then dragged it woul
sense the logic but I haven't had success.
Thank
This is my first post. Thanks for all of your help in advance. I a
working with a multi-sheet workbook. I am creating a 'summary' page an
am creating a 'total' sold of a product with multiple options.
Formula is:
Cell E14 =SUM(CLOTH!G10:G21)
I want to drag this formula down through E20 and have each cell on m
'total' page read as follows:
E15 =SUM(CLOTH!G30:G41)
E16 =SUM(CLOTH!G50:G61)
E17 =SUM(CLOTH!G70:G81)
There is a gap between the cells needed to create the formula here. I
there a way to drag down a formula and have excel do the rest? I though
that maybe if I entered 2-3 of them initially and then dragged it woul
sense the logic but I haven't had success.
Thank