Using Dynamic Arrays and The XlLOOKUP function

jazzista

Board Regular
Joined
Sep 15, 2014
Messages
73
Hello Board: I have created a dynamic crostabulated table using the new XLOOKUP function with SORT and UNIQUE so that I can get dynamic toggle between rows and columns. It worked pretty good. The problem I am having is when I am trying to use SUMIFS to dynamically aggregate both row and column criterias , I am getting an error where I think I am not closing a parenthesis somewhere in the formula. Attached is the link to the file.
As always, thanks for the help.






https://www.dropbox.com/s/xvyyook0uvosyja/dynamic%20arrays.xlsx?dl=0
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,099,330
Messages
5,467,976
Members
406,561
Latest member
Grappledog

This Week's Hot Topics

Top