Saturday, November 24, 2018

yogi_Compute Cumulative Sum Of Entries In Every Third Column Of B1:1

Google Spreadsheet   Post  #2550

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Nov-24-2018

How to Make Formula Only Sum Every Third Column?
I'm currently using this formula: ArrayFormula(IF(Len(I12:12), (sumif(Column($I12:12), "<="&column(I12:12), $I12:12)),)
How would i get it to only look at the numbers in every third column. Here is a spreadsheet showing the problem in more detail:


No comments:

Post a Comment