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
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!