Average of the first 3 numbers and average of the 4th+ number

I'm trying to find the average of the first 3 months of data and then find the average of the 4th month and beyond of data. So for instance, the first row, the average of the red values and then the average of the green values.

The start of data for every row could be different and the number total values of each row could be different.

Anyone have a formula that I could apply for each row rather than having to calculate the two averages manually?

Thanks in advance.




  • brianschmidt
    brianschmidt ✭✭✭✭✭

    You could create a series of nested IF statements that check which rows are blank to find a starting point. However, depending on the number of month columns you are going to have in this sheet, that formula could get very long.

    In general, I've found it is easier to check for blanks and positioning when going off of rows as opposed to columns. However, not knowing what's going on with the rest of this sheet, it's hard to tell what challenges reorganizing that data could create.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!