Hi,
I need to calculate the volume of a frustum (cone) across a dataset given by:
wefds.png
The caveat is that I need to reference every nth cell and SUM all the values in one cell, less the tedious manual input.
For example, referencing every 3rd cell (n=3).
I would need to do this for n=5, 10, 30 etc. and would like to know how to modify the formula accordingly.Please Login or Register to view this content.
Appreciate any help!
Bookmarks