Formula Assistance

cbonnell

Hello Everyone,

I need assistance creating a formula that will give the sum of every fifth cell in a single column.

Schiff A.

Hi cbonnell!

 

In order to best assist you I'd like to understand a bit more about your use case and how your sheet is organized. There may be a better solution than using to calculate a sum of every 5th cell in a column.



For example, you may be able to take advantage of row hierarchy and the hierarchy functions (CHILDREN, PARENT, ANCESTORS) to create rollups.

See these articles for more information:



https://help.smartsheet.com/functions

https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows

Thanks,

Schiff

 

 

CanadaJim

Just throwing this out there:

You can always have a new extra column that repeatedly counts 1-5

=IF(CountCellAbove=5,1,CountCellAbove + 1)

Then your Sum formula can be:

=IF(CountCellCurrentRow=5,SumCellAbove+CurrentRowValue,SumCellAbove)

If you need more help understanding what I mean, let me know.

Jim