Hi,
My s/s currently has the correct formulas for below based on Year. I was hoping someone would be able to help me fill in for the quarter by year starting in. Please let me know if you have any questions.
Please Login or Register to view this content.
best,
Adam
Looks like you are using an XL version which is not, as indicated in your profile, XL2010??
I have Microsoft 365 MSO
just wanted to follow up to see if anyone had any questions
best,
Adam
thought I would give this one more chance to see if anyone can help out before closing it out
It is easier to help when we have manually calculated results with which to compare the results of our formulas/code.
I feel as if the following does what you want:
1. For J16 and down: =IFNA(INDEX(AC$7:AC$29,MATCH(G16,AE$7:AE$29,0)),"-")
2. For L16 and down: =MAX(0,J17-J16)
3. For N16 and down: =IF(J17="",0,MIN(0,J17-J16))
4. For P16 and down: =IF(J16="-",SUM(L16,N16),SUM(J16,L16,N16))
5. For T16 and down: =AVERAGEIFS(AC$7:AC$29,AE$7:AE$29,G16)
Columns V and Z seemed to calculate correctly.
Cells AC7 and down could be populated using: =SUMPRODUCT((B$7:B$73<=EOMONTH(AB7,0))*(D$7:D$73>EOMONTH(AB7,0)+1)) and there is no need to array enter the formula, just press the Enter key.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks