nth cell

  1. A

    Sum Every nth Cell -Ignoring Errors in Range

    This has been asked before, answered and solved here: https://www.mrexcel.com/forum/excel-questions/503738-sum-every-other-cell-ignoring-errors-range.html The reason I'm revisiting it, is because I don't understand enough about how these formulas work. The solution given to this user worked for...
  2. D

    Plotting a graph with every nth cell

    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)...
  3. andrewb90

    sum on every 17th column

    Hello all, I found this formula online, and It's just not quite working as intended. =SUMPRODUCT((MOD(COLUMN($D4:$II4),17)=0)*($D4:$II4)) I'm wanting it to cum the value of every 17th cell, however when I change it to 17 it counts the 17th column first(q) then every 17, But I'm wanting the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top