Continue formula, skipping every 4th row, without skipping reference?

[ndeaette]

Hi all,

I'm working on a pretty hefty spreadsheet right now which will tally scores during our application review process. The sheet currently has 3 sheets, one with raw scores, one with weight values, and one where I'm multiplying raw scores by their weight values to get weighted scores.

The weighted scores tab has 4 rows in each section (because there is a total row) but the raw scores tab only has 3, so I can't copy the formula down because I need to account for the total row.

Is there any way to continue a formula down the column, skipping every 4th row (the total row) without skipping a reference on the other sheet?

Hopefully this makes sense, I'm having a hard time explaining.

 

[Rick Rothstein]

Perhaps you can give us a hint as to your data layout and exactly what parts of it need to be multiplied. Posting a sample copy of your workbook to DropBox so we can download it and see where everything is located at would be even better (make sure to show us the result you want from the sample numbers you post).

 

[ndeaette]

Perhaps you can give us a hint as to your data layout and exactly what parts of it need to be multiplied. Posting a sample copy of your workbook to DropBox so we can download it and see where everything is located at would be even better (make sure to show us the result you want from the sample numbers you post).

Here's a Dropbox link to the spreadsheet: https://www.dropbox.com/s/735mhzismyjjpxt/Final Scoring.xlsx?dl=0

Look at the "weighted scores" tab, and notice what I've started doing in column E. Notice how E8 pulls data from T7 in Raw scores, and E10 pulls data from T8. I had to do this manually but I'm hoping there's a way to get the formula to skip over a cell in the E column without skipping over anything from the Raw Scores tab.