Forum Discussion
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)
Presenta #N/D
Presenta #¡DESBORDAMIENTO!
| 1 | -4.5 | 20.25 |
| 2 | -3.5 | 12.25 |
| 3 | -2.5 | 6.25 |
| 4 | -1.5 | 2.25 |
| 5 | -0.5 | 0.25 |
| 6 | 0.5 | 0.25 |
| 7 | 1.5 | 2.25 |
| 8 | 2.5 | 6.25 |
| 9 | 3.5 | 12.25 |
| 10 | 4.5 | 20.25 |
| #N/D | #¡DESBORDAMIENTO! | #N/D |
In Spanish, COUNT is CONTAR and COUNTA is CONTARA
3 Replies
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.Tks a lot dscheikey
Microsoft® Excel® para Microsoft 365 MSO (versión 2209 compilación 16.0.15629.20152) de 64 bits
No Way...
- The COUNT() function NOT FOUND
- The COUNTA() FUNCTION NOT FOUND
In Spanish, COUNT is CONTAR and COUNTA is CONTARA
