Mon 1er question, sur une fonctin simple
salur les amis
j'ai un problem et je veux trouver un fonction utiliser en excel pour calculer les celules ecrire "pas vide" dans un plage declare
par ecxeple : si j'ai declare un plage de 8 celule, et si j'ai ecrite dans trois celules donc dans la celule de la fonctin il va affiche 3
NB : desole pour ma français, i hope that you understood me.
Be welcome imadov10, I understood your question. However I'll have to reply in french
Dans la cellule de la fonction, tu mets ceci:
=SOUS.TOTAL(3;nom_de_la_plage)ou
=SOUS.TOTAL(3;A1:A8)A+
Francois.
Salut le forum , Hi imadov10 and FrancoisM
French is not your native lanuguage, but we understand your question, you can try this
=NBVAL(A1:A8) Translation =COUNTA(A1:A8)
Or =SOUS.TOTAL(3;A1:A8) Translation =SUBTOTAL(3,A1:A8) like FrancoisM
Adapte in formula, the A1:A8 to your plage of cells
Mytå
FrancoisM a écrit :Be welcome imadov10, I understood your question. However I'll have to reply in french
Dans la cellule de la fonction, tu mets ceci:
=SOUS.TOTAL(3;nom_de_la_plage)ou
=SOUS.TOTAL(3;A1:A8)A+
Francois.
merci bien
Mytå a écrit :Salut le forum , Hi imadov10 and FrancoisM
French is not your native lanuguage, but we understand your question, you can try this
=NBVAL(A1:A8) Translation =COUNTA(A1:A8)
Or =SOUS.TOTAL(3;A1:A8) Translation =SUBTOTAL(3,A1:A8) like FrancoisM
Adapte in formula, the A1:A8 to your plage of cells
Mytå
thank you
yes it's not my first language
thanks again
Edit: By Mytå, desactivate the smileys in this message
Re Welcome imadov10
Thanks for your reply, to your first message.
If your are other question, I hope you think at this forum.
Mytå
P.S. The english is not my native language, but like you, I make my effort
Mytå a écrit :Re Welcome imadov10
Thanks for your reply, to your first message.
If your are other question, I hope you think at this forum.
Mytå
P.S. The english is not my native language, but like you, I make my effort
bien sure mon ami, je veux etre un etudient dans ce forum
pour les question : je ne sais pas si je peut poser des question sur access aussi ou seulement exel
merci