Contar.si Conjunto (Excepción de valores)

%3CLINGO-SUB%20id%3D%22lingo-sub-2544244%22%20slang%3D%22es-ES%22%3EContar.si%20Set%20(Value%20Exception)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2544244%22%20slang%3D%22es-ES%22%3E%3CP%3EHello%20how%20can%20I%20generate%20a%20function%20with%20contar.si%20set%20that%20does%20not%20contemplate%20one%20or%20more%20values%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eexample%20in%20the%20database%20I%20have%20date%20information%20and%20a%20response%20type%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20function%20will%20contemplate%20all%20the%20data%20collected%20in%20the%20month%20of%20July%202020%2C%20except%20type%20of%20response%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20%22does%20not%20answer%22%3C%2FP%3E%3CP%3E%22it%20doesn't%20tone%22%20%3CBR%20%2F%3E%20%22no%20number%22%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20hope%20you%20can%20support%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2544244%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2548185%22%20slang%3D%22en-US%22%3ERe%3A%20Contar.si%20Conjunto%20(Excepci%C3%B3n%20de%20valores)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2548185%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1102575%22%20target%3D%22_blank%22%3E%40Emilio_DieFlo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Demo.png%22%20style%3D%22width%3A%20258px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295859i119E4C061B4E8C18%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Demo.png%22%20alt%3D%22Demo.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20way%20in%26nbsp%3B%3CSTRONG%3ED5%3C%2FSTRONG%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DSUMPRODUCT(%0A%20%20%20%20(Table1%5BDate%5D%20%26gt%3B%3D%20DATE(2020%2C7%2C1))%20*%20(Table1%5BDate%5D%20%26lt%3B%20DATE(2020%2C8%2C1))%20*%0A%20%20%20%20ISNA(%20MATCH(Table1%5BResponse%20type%5D%2C%7B%22does%20not%20answer%22%2C%22it%20doesn't%20tone%22%2C%22no%20number%22%7D%2C0)%20)%0A)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hola como puedo generar una función con contar.si conjunto que no contemple uno o mas valores

 

ejemplo en la base tengo información de fecha y un tipo de respuesta:

 

la función contemplara todos los datos recabados en el mes de Julio 2020, excepto tipo de respuesta:

"no contesta"

"no da tono"
"sin numero"

espero me puedan apoyar.

1 Reply

@Emilio_DieFlo 

 

Demo.png

 

On way in D5

=SUMPRODUCT(
    (Table1[Date] >= DATE(2020,7,1)) * (Table1[Date] < DATE(2020,8,1)) *
    ISNA( MATCH(Table1[Response type],{"does not answer","it doesn't tone","no number"},0) )
)