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.
Jennifer
Answers

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
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 320 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 276 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!