Forum Discussion

Ricardo_Ismael's avatar
Ricardo_Ismael
Copper Contributor
Sep 30, 2022
Solved

Falla Función RECUENTOCONJUNTOCUBO

Trabajando con Excel 365...   Requiero la cuenta de elementos de una columna...       Falla la función =RECUENTOCONJUNTOCUBO() =RECUENTOCONJUNTOCUBO(A3) =RECUENTOCONJUNTOCUBO(B3:B26) Present...
excel
Formulas and Functions
dscheikey's avatar
dscheikey
Bronze Contributor
Oct 01, 2022

Ricardo_Ismael 

Hi Ricardo, for the function CUBESETCOUNT() you need a data model. This function is specially made for that.

To count the entries only in a cell range, you can use COUNT() or COUNTA().


I hope this has helped you.

 

  • Ricardo_Ismael's avatar
    Ricardo_Ismael
    Copper Contributor
    Oct 02, 2022

    Tks a lot dscheikey 

     

    Microsoft® Excel® para Microsoft 365 MSO (versión 2209 compilación 16.0.15629.20152) de 64 bits

     

    No Way...

    1. The COUNT() function NOT FOUND
    2. The COUNTA() FUNCTION NOT FOUND
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Oct 03, 2022

      Ricardo_Ismael 

      In Spanish, COUNT is CONTAR and COUNTA is CONTARA