Ola pessoal, 

Estou tentando usar o CONT.SES para excluir a contagem de alguns valores e tambem nao contar o mes usado de referencia na celula V1,

Meu CONT.SES precisa de ter as seguintes regras:

->Na Tab All Members-> Coluna AY:
TIRAR MES ATUAL ou seja nao preciso contar o mes/ano de referencia da Celula V1

->Na Tab All Members-> Coluna BG:
Tirar Child and Employee

->Na Tab All Members-> Coluna BH:
Tirar 1 month membership [pra cada area]

Tirar 3 month membership [pra cada area]
Superadmin_only_apple_review
Complementary Membership

Estou utilizando essa formula:

=CONT.SES('All Members'!A2:A90000,"<>"&"",
'All Members'!A2:A90000,"="&"Gym Plus Ashbourne",
'All Members'!BG2:BG90000,"<>"&"Child",
'All Members'!BG2:BG90000,"<>"&"Employee",
'All Members'!BH2:BH90000,"<>"&"1 month membership Ashbourne",
'All Members'!BH2:BH90000,"<>"&"1 month membership Ballsbridge",
'All Members'!BH2:BH90000,"<>"&"1 month membership Cork",
'All Members'!BH2:BH90000,"<>"&"1 month membership Drogheda",
'All Members'!BH2:BH90000,"<>"&"1 month membership Naas",
'All Members'!BH2:BH90000,"<>"&"1 month membership Rathfarnham",
'All Members'!BH2:BH90000,"<>"&"1 month membership Swords",
'All Members'!BH2:BH90000,"<>"&"3 month membership Ashbourne",
'All Members'!BH2:BH90000,"<>"&"3 month membership Ballsbridge",
'All Members'!BH2:BH90000,"<>"&"3 month membership Cork",
'All Members'!BH2:BH90000,"<>"&"3 month membership Drogheda",
'All Members'!BH2:BH90000,"<>"&"3 month membership Naas",
'All Members'!BH2:BH90000,"<>"&"3 month membership Rathfarnham",
'All Members'!BH2:BH90000,"<>"&"3 month membership Swords",
'All Members'!BH2:BH90000,"<>"&"Superadmin_only_apple_review",
'All Members'!BH2:BH90000,"<>"&"Complementary Membership",
'All Members'!AY2:AY90000,">"&0,'All Members'!AY2:AY90000,"<"&V1)+CONT.SE('All Members'!AY2:AY90000,">="&FIMMÊS(V1,0)+1)

mas esta contando errado!

Quando voce vai na Aba All Members e filtra os valores , o valor fica contraditório com a aba Overview.

Segue a planilha em anexo.

Alguem consegue me ajudar?

Obrigado