I'd like to get some data depending on multiple entries.
I'm using the "NB.SI.ENS()" which is "COUNTIFS()" in English if I'm not mistaken.
I have multiple entries, which would represent a 3D array since I'm using 3 Sources. Those Sources are an Activity, a Project, and a Date.
For each one, I need to count the triplets (Activity, Project, Date). My exemple in the Image shows 3 for the Number of Tests in Project 1 on the 10th Month.
With two Sources, the COUNTIFS() functions work okay. I can do this with as much COUNTIFS() as there are intersection between Rows and Columns from the two Sources (for instance, Activities, and Projects)
With 3 entries, I need to make as much 2D arrays as there are datas in the third array.
I've chosen the Dates as the 3rd array, so I have 12 2D arrays.
This uses a lot of computation time from Excel when I'm getting over 200 ligns of data.
Is there a better way to do that?