Complex formula Help

Could someone break this formula piece by piece and explain how it works to me? it works appropriately in my file, but I am unsure how exactly it works. Specifically the Counta thru +6 portion. I was able to get a decent handle on the other sections of the forumla through google, but would appreciate any insight put as simply as possible. Thank you in advance

 

=Offset($A$1,ROW()-1,((COLUMN())*2-((COUNTA($B$4:$UY$4)*2)+6)),1,1)-Offset($A$1,ROW()-1,((COLUMN())*2-((COUNTA($B$4:$UY$4)*2)+7)),1,1) 

By: Adam

Leave a Reply

Your email address will not be published. Required fields are marked *