every nth cell

I have a structured table called Prod_TechT that is in B82:IX106 that I what to count the Number of "Y"s in every seventh column in IW82..106. This worked =SUMPRODUCT(N(MOD(COLUMN($B82:IV82)-1,7)=0),N($B82:IV82="Y")), but I want to converted it to the structured names. i.e...

Hi, I want to reference the cell A6 in cell W6. So I use =A6. I want to reference every 3rd cell so the next cell I want to reference is A9. W7 = A9 W8 = A12 etc How do I fill down W6 to reference every 3rd cell? Thanks, Gerry

Hi guys, I am trying to plot a graph but I have a lot of data. I have 213,792 rows of data but Excel only lets you plot 32,000 data points on a graph. How do I plot every 7th row of data instead? Below is a small look at what my columns look like (and the rows would be filled in of course)...

Hi I'm having a few issues with copy and pasting a formula into the adjacent columns, but being able to over ride the cells it picks up on another sett for every 3rd column. for example I have the formula '2a Substructure'!$S$8+'2a Substructure'!S9+SUM('2a Substructure'!S150*2%) I need the...

Hi everybody! I am quite new to attempting anything advanced on excel. So I'll try to provide as much information as possible. I am using Excel 2013 on Windows 8. I have a list of single words in each cell. Some of them are the exact same word, however most of them only occur once. The first...