count cells with specific text, then sum employees numbers

[NicBKK]

Hi Gurus,

I have a number of employees and whether they are shared or not
I am able to count the number of shared titles, but I am struggling to sum the total number of shared employees.

I tried in the excel sheet attached but i'm failing

Please help, Thanks a lot

[:) Sixthsense :)]

In F4 Cell

Please Login or Register  to view this content.

[CARACALLA]

F4=sumif(a3:a20,"*~**",b3:b20)