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 **10**th Month.

[![This is the representation](https://i.stack.imgur.com/OhWLM.jpg)](https://i.stack.imgur.com/OhWLM.jpg)

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?