If it isn't broken, why try to fix it?How can I optimize the following formula - putting it in just one Countifs?
Because I am trying to use those formulas in a dynamic array, and I am not capable of putting them as a SUM inside the dynamic array. So I thought that maybe by mixing it, it would work.If it isn't broken, why try to fix it?
There is nothing that you can do with that other than use a smaller count range, e.g to use a range that is big enough to include all of the data instead of the entire column.
DATE (A) | CASE (B) | CHECK (C) | SOLUTION (D) | TYPE (E) | VALUE (F) |
21/05/2021 | P | DONE | 28/05/2021 | 4,85 | |
21/05/2021 | P | DONE | 02/06/2021 | R. | 8.893,96 |
22/05/2021 | CA | MISSING | 400.000,00 | ||
22/05/2021 | P | DONE | 28/05/2021 | 1,67 | |
22/05/2021 | CS | DONE | 02/06/2021 | R. | 355.791,00 |
22/05/2021 | CS | DONE | 02/06/2021 | R. | 358,64 |
22/05/2021 | CS | DONE | 02/06/2021 | R. | 358,64 |
22/05/2021 | CS | DONE | 02/06/2021 | R. | 355.791,00 |
22/05/2021 | CA | DONE | 15/06/2021 | 400.000,00 | |
25/05/2021 | CO | DONE | 28/05/2021 | 100.000,00 | |
25/05/2021 | P | DONE | 01/06/2021 | 5,25 | |
25/05/2021 | F | DONE | 02/06/2021 | R. | 7.300.000,00 |
26/05/2021 | CA | DONE | 16/06/2021 | 1.718.000,00 | |
26/05/2021 | CO | DONE | 01/06/2021 | 422.832,98 | |
26/05/2021 | CO | DONE | 02/06/2021 | R. | 1.086,77 |
26/05/2021 | CO | DONE | 02/06/2021 | R. | 1.086,77 |
26/05/2021 | CO | DONE | 02/06/2021 | R. | 983,74 |
26/05/2021 | CO | DONE | 03/06/2021 | 7250 | 9.244.707,41 |
26/05/2021 | CO | DONE | 03/06/2021 | 7250 | 8.336.807,00 |
26/05/2021 | CA | DONE | 15/06/2021 | 1.500.000,00 | |
27/05/2021 | CA | MISSING | 480.000,00 | ||
27/05/2021 | P | DONE | 01/06/2021 | 15,75 | |
27/05/2021 | CA | DONE | 02/06/2021 | R. | 4.363,23 |
27/05/2021 | CA | DONE | 02/06/2021 | R. | 4.363,23 |
27/05/2021 | CA | DONE | 15/06/2021 | 400.000,00 | |
28/05/2021 | PF | DONE | 01/06/2021 | 0,97 | |
28/05/2021 | FV | DONE | 02/06/2021 | R. | 714.000,00 |
28/05/2021 | CA | DONE | 15/06/2021 | 1.428.000,00 |
No!Do you have the LET function?
Can I download a library or something?In that case I would recommend you keep the three separate formulae.