Count of filtered rose visible on TOTAL

Hello,

I am trying to count "Col1a" rows for "segment 2" and show the result on the last line as you can see in the file enclosed.

Of course the idea is then to do the same for segment 4 and 5 and sum of all segments.

Any idea ?

Clement

Hi Clem,

Is this what you'r looking for ?

Regards,

Hi Gabin,

Yes but if I want to make it in a VB script, it is because it has to be done for all column

Plus in the Col1b, Col2b, Col3b, Col4b, Col(B, there is another calculation to make :

Col1b = (Sum of "Number" for segment 2/Number of rows for segment 2)*1000

So that would be great to launch a VBA and have the results.

Mmmmh, I am not sure to understand correctly your demand.

Is the result in this Workbook correct ?

If yes, I can make a VBA program (you should ask since the first post it must be VBA)

I just want to be sure I have the correct solution before

No. It is more like this.

I have made it with functions and only for Col1a.

Bonjour,

Tu utilises une version 365 puisque tu utilises la fonction Filtre() !

Une proposition par formule (figeage des colonnes). Pourquoi VBA ?

B266 :     =SORT(UNIQUE(Tableau2[SEGMENT]))
G272 :     =COUNT(FILTER(Tableau2[COL1a];Tableau2[[SEGMENT]:[SEGMENT]]=$C2))/$F2*1000

Cdlt.

Excellente idée @Jean-Eric Merci.