Welcome to the forum.
With the date 01/03/2024 in P1, try this in M2:
=LET(u,UNIQUE(A2:B21),f,FILTER(u,(INDEX(u,,2)>=P1)*(INDEX(u,,2)<EDATE(P1,1))),AVERAGE(MAP(INDEX(f,,1),INDEX(f,,2),LAMBDA(i,d,SUMPRODUCT((A2:A21=i)*(B2:B21=d)*J2:J21)))))
Does it produce your expected result? If not, what should the expected result be?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Melissa_8 
Register To Reply
Bookmarks