Optimize Formula

[Leticia]

Hi!
How can I optimize the following formula - putting it in just one Countifs?

COUNTIFS('D'!$P:$P;"OTRO";'D'!$G:$G;"<="&$F$4)+COUNTIFS('D'!$G:$G;"<="&$F$4;'D'!$Q:$Q;">"&$F$4)

Thank you!

 

[Leticia]

Ok, I thought that you were trying to merge all 3 formulae into one, so that it would spill 5 rows & 6 columns, rather than trying to change the formulae.
Those 3 formula are doing completely different things. If they are not what you want, then you will need to rethink your approach.

Yeah I know, they are calculating what I want it is just that when Scenario 1 occurs I need the results from 1+ the results from 2
And in Scenario 2 i need the results from 1+ the results from 2.

My problem is that I dont know how to obtain the top 5 dynamic array with the sum of 1+2 in one case, and another different dynamic array (in another table) with the sum of 1+3

 

[Fluff]

As this has become a totally different question from your op & I have no idea what you are trying to do. I suggest that you start a new thread with some sample data & explain in words (not formulae) what you are trying to do.

 

[Leticia]

As this has become a totally different question from your op & I have no idea what you are trying to do. I suggest that you start a new thread with some sample data & explain in words (not formulae) what you are trying to do.

Great! Done in Dynamic Arrays - Top 5 values

 

[Fluff]

Thanks.

 

[Leticia]

Great! Done in Dynamic Arrays - Top 5 values

Solved in Dynamic Arrays - Top 5 values