# Excel Formula **URL:** \ **Category:** Ask for Help\ **Created:** [May 25, 2021, 1:58am UTC](https://community.glideapps.com/t/excel-formula/27191 "2021-05-25T01:58:15Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [May 25, 2021, 1:58am UTC](https://community.glideapps.com/t/excel-formula/27191/1 "2021-05-25T01:58:15Z")
Can anyone help me, I have a page data like: (PAGE 1) Model 1 | Quantity Year 18 | 3 Year 19 | 5 Year 20 | 1 Year 21 | 2 Model 2 Year 18 | 13 Year 19 | 15 Year 20 | 11 Year 21 | 12 … … And others model In other sheet. The formula in the cell will be Year 18 Model 1 ='PAGE 1!A2 Model 2 ='PAGE 1!A6 It add 4 from the first cell (A2 to A6) What is the formula to easy drag because the model like a lot. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 25, 2021, 2:04am UTC](https://community.glideapps.com/t/excel-formula/27191/2 "2021-05-25T02:04:09Z")
Can you go into more details or include some screenshots? Do you mean you want to include all models in a Sheet where it would look like. Model | Year | Quantity Model 1 | Year 18 | 3 Model 1 | Year 19 | 5 … Model 2 | Year 18 | 13 Model 2 | Year 19 | 15 ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [May 25, 2021, 2:09am UTC](https://community.glideapps.com/t/excel-formula/27191/3 "2021-05-25T02:09:31Z")
This is my raw data: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94b9b025dad254a29ab95975029f01305f2c7236.png) I want to summarize for example year 2019: CASE : 0 ='PAGE 1!C14 CATERPILLAR:17 ='PAGE 1!C20 HITACHI:19 ='PAGE 1!C26 I need it to drag down automatic go c14\>c20\>c26\>c32\>c38 Add 6 for each row ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 25, 2021, 7:14am UTC](https://community.glideapps.com/t/excel-formula/27191/4 "2021-05-25T07:14:23Z")
Hi @biha , just a few comments: 1. As of writing, as far as I know you can use a Google Sheet or Glide Tables to store your raw data in tables, not Excel. 2. The data in your spreadsheet should be organized in a specific way to be exploited in your app. [Organizing your spreadsheet](https://docs.glideapps.com/all/guides/quick-starts/getting-started/organizing-your-spreadsheet) 3. To “pull” a formula in Google Sheet, have you tried arrayformula ? Excel probably has the same or equivalent formula? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [May 25, 2021, 7:46am UTC](https://community.glideapps.com/t/excel-formula/27191/5 "2021-05-25T07:46:50Z")
I understand that. For your comment number 1: To pull from my excel to google sheet, my data must be organized. So i need make some summarization . ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 25, 2021, 9:56am UTC](https://community.glideapps.com/t/excel-formula/27191/6 "2021-05-25T09:56:19Z")
The screenshot from Excel is kind of irrelevant, because that doesn’t connect to Glide. If you can show what your _GoogleSheet_ looks like, it would be easier to provide some guidance/assistance. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [May 25, 2021, 3:42pm UTC](https://community.glideapps.com/t/excel-formula/27191/7 "2021-05-25T15:42:00Z")
I’d have to dig into it further to see what the excel equivalent is with the formulas, but I think you might be able to use something like INDIRECT or ROW to dynamically build a cell reference from another cell or from the row number. Also thinking you could maybe do something where you multiply a row number by 6 or add 6 for example to let the drag down auto increment properly…But as I look at your screenshot, I’m not sure how a drag down formula would work because you would have multiple years that you are trying to sum in the same column. Where is that summarized total supposed to be stored? Do you have the same number of equipment manufactures, or can that number change? Unless I’m misunderstanding, I don’t think you want a formula to drag down. Instead you might want a formula in a single cell that adds up the totals for every nth row. Something like this: > **[Sum Every nth Row in Excel](https://www.excel-easy.com/examples/sum-every-nth-row.html)** > > This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3, but you can do this for any number.