{"id":6754,"date":"2025-07-15T13:34:48","date_gmt":"2025-07-15T13:34:48","guid":{"rendered":"https:\/\/functiontranslator.com\/lignes\/"},"modified":"2021-02-26T08:13:09","modified_gmt":"2021-02-26T08:13:09","slug":"rows","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/fr\/rows\/","title":{"rendered":"LIGNES"},"content":{"rendered":"

Description et Syntaxe de la fonction LIGNES<\/h2>\n

La fonction LIGNES, disponible dans Microsoft Excel et Google Sheets, permet de compter le nombre de lignes dans une plage de cellules d\u00e9finie. Cette fonction est particuli\u00e8rement utile pour automatiser des processus o\u00f9 la dimension de la plage peut varier.<\/p>\n

Syntaxe :<\/strong> LIGNES(plage)<\/code><\/p>\n

Le param\u00e8tre plage<\/em> correspond aux cellules dont le nombre de lignes doit \u00eatre d\u00e9termin\u00e9.<\/p>\n

Exemple :<\/strong><\/p>\n

A 1 10 2 20 3 30<\/code><\/pre>\n
L’utilisation de LIGNES(A1:A3)<\/code> retournera 3, car il y a trois lignes dans la plage de A1 \u00e0 A3.<\/p>\n
Utilisation Pratique<\/h2>\n
Explorons quelques utilisations pratiques de la fonction LIGNES pour illustrer sa capacit\u00e9 \u00e0 am\u00e9liorer l’efficacit\u00e9 des t\u00e2ches.<\/p>\n
Calcul du Nombre Total d’Entr\u00e9es<\/h2>\n
Imaginez que vous avez une liste d’\u00e9tudiants et souhaitez d\u00e9terminer le nombre total d’inscrits.<\/p>\n
A 1 Alice 2 Bob 3 Charlie 4 David<\/code><\/pre>\n
En utilisant la fonction LIGNES(A1:A4)<\/code>, Excel ou Google Sheets indiquera 4, soit le nombre total d’\u00e9tudiants r\u00e9pertori\u00e9s.<\/p>\n
\u00c9tapes \u00e0 suivre :<\/strong><\/p>\n
    \n
  • Entrer la formule =LIGNES(A1:A4)<\/code> dans une cellule vide.<\/li>\n
  • Appuyer sur ‘Entr\u00e9e’ pour obtenir le r\u00e9sultat.<\/li>\n<\/ul>\n
    Int\u00e9gration dans une fonction conditionnelle<\/h2>\n
    Supposons que vous g\u00e9rez un inventaire et avez besoin de r\u00e9aliser une op\u00e9ration sp\u00e9cifique si le nombre de produits exc\u00e8de 10. Il est possible d’incorporer la fonction LIGNES dans une instruction conditionnelle pour y parvenir.<\/p>\n
    A 1 Produit A 2 Produit B ... 11 Produit K<\/code><\/pre>\n
    Vous pouvez utiliser la formule suivante :<\/p>\n
     SI(LIGNES(A1:A11) > 10, \"V\u00e9rifier l'inventaire\", \"Inventaire OK\")<\/code> <\/pre>\n
    Cette formule \u00e9value si le nombre de lignes dans la plage A1 \u00e0 A11 d\u00e9passe 10. Si oui, elle affiche \u00ab\u00a0V\u00e9rifier l’inventaire\u00a0\u00bb; sinon, elle indique \u00ab\u00a0Inventaire OK\u00a0\u00bb.<\/p>\n
    \u00c9tapes \u00e0 suivre :<\/strong><\/p>\n
      \n
    • Entrer la formule mentionn\u00e9e dans une cellule appropri\u00e9e.<\/li>\n
    • Appuyer sur ‘Entr\u00e9e’ pour visualiser le r\u00e9sultat.<\/li>\n<\/ul>\n
      Ces exemples d\u00e9montrent comment la fonction LIGNES peut \u00eatre utilis\u00e9e pour automatiser et simplifier les analyses et contr\u00f4les dans divers contextes pratiques.<\/p>\n","protected":false},"excerpt":{"rendered":"
      Renvoie le nombRe de lignes dans une R\u00e9f\u00e9Rence<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[312],"tags":[],"class_list":["post-6754","post","type-post","status-publish","format-standard","hentry","category-recherche-et-matrices"],"acf":[],"yoast_head":"\nFonction ROWS (LIGNES) dans Excel : comment \u00e7a marche, exemples et syntaxe<\/title>\n<meta name=\"description\" content=\"Pr\u00e9sentation de la fonction ROWS (LIGNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/fr\/rows\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fonction ROWS (LIGNES) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta property=\"og:description\" content=\"Pr\u00e9sentation de la fonction ROWS (LIGNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/fr\/rows\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:13:09+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Fonction ROWS (LIGNES) dans Excel : comment \u00e7a marche, exemples et syntaxe\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/rows\/\",\"url\":\"https:\/\/functiontranslator.com\/fr\/rows\/\",\"name\":\"Fonction ROWS (LIGNES) dans Excel : comment \u00e7a marche, exemples et syntaxe\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:48+00:00\",\"dateModified\":\"2021-02-26T08:13:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Pr\u00e9sentation de la fonction ROWS (LIGNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/fr\/rows\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/fr\/rows\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/fr\/rows\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Fonctions Excel\",\"item\":\"https:\/\/functiontranslator.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Recherche et matrices\",\"item\":\"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"LIGNES\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fonction ROWS (LIGNES) dans Excel : comment \u00e7a marche, exemples et syntaxe","description":"Pr\u00e9sentation de la fonction ROWS (LIGNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/fr\/rows\/","og_locale":"fr_FR","og_type":"article","og_title":"Fonction ROWS (LIGNES) dans Excel : comment \u00e7a marche, exemples et syntaxe","og_description":"Pr\u00e9sentation de la fonction ROWS (LIGNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","og_url":"https:\/\/functiontranslator.com\/fr\/rows\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:48+00:00","article_modified_time":"2021-02-26T08:13:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Fonction ROWS (LIGNES) dans Excel : comment \u00e7a marche, exemples et syntaxe","twitter_misc":{"\u00c9crit par":"glavadmin","Dur\u00e9e de lecture estim\u00e9e":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/fr\/rows\/","url":"https:\/\/functiontranslator.com\/fr\/rows\/","name":"Fonction ROWS (LIGNES) dans Excel : comment \u00e7a marche, exemples et syntaxe","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:48+00:00","dateModified":"2021-02-26T08:13:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Pr\u00e9sentation de la fonction ROWS (LIGNES) d\u2019Excel et Google Sheets. Syntaxe d\u00e9taill\u00e9e et exemples pratiques d'utilisation.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/fr\/rows\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/fr\/rows\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/fr\/rows\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Fonctions Excel","item":"https:\/\/functiontranslator.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Recherche et matrices","item":"https:\/\/functiontranslator.com\/fr\/recherche-et-matrices\/"},{"@type":"ListItem","position":3,"name":"LIGNES"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/fr\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/comments?post=6754"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6754\/revisions"}],"predecessor-version":[{"id":29765,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/posts\/6754\/revisions\/29765"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/media?parent=6754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/categories?post=6754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/fr\/wp-json\/wp\/v2\/tags?post=6754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}