{"id":51625,"date":"2024-12-10T14:00:00","date_gmt":"2024-12-10T13:00:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=51625"},"modified":"2025-06-03T22:11:45","modified_gmt":"2025-06-03T20:11:45","slug":"maitriser-la-formule-de-requete-4-cas-dutilisation","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/google-sheets-formulas\/mastering-query-formula-4-use-cases\/","title":{"rendered":"Ma\u00eetriser la formule QUERY : 4 cas d'utilisation avec exemples"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

The QUERY formula in Google Sheets is a powerful tool for filtering, grouping, and summarizing data. With this formula, you can simplify data management, perform advanced analysis, and create detailed reports.<\/span><\/p>\n

In this blog, we\u2019ll explore four practical use cases to demonstrate how the QUERY formula can transform your workflows.<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

1. Streamlining inventory management<\/b><\/h2>\n

Scenario: A warehouse manager needs to retrieve details about oversold products and calculate daily out-of-stock totals from inventory records.<\/span><\/p>\n\n\n\n\n\n\n\n
\n

A<\/b><\/p>\n<\/td>\n

\n

B<\/b><\/p>\n<\/td>\n

\n

C<\/b><\/p>\n<\/td>\n<\/tr>\n

\n

Product<\/span><\/p>\n<\/td>\n

\n

Stock<\/span><\/p>\n<\/td>\n

\n

Sales<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Product A<\/span><\/p>\n<\/td>\n

\n

50<\/span><\/p>\n<\/td>\n

\n

60<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Product B<\/span><\/p>\n<\/td>\n

\n

30<\/span><\/p>\n<\/td>\n

\n

15<\/span><\/p>\n<\/td>\n<\/tr>\n

\n

Product C<\/span><\/p>\n<\/td>\n

\n

10<\/span><\/p>\n<\/td>\n

\n

20<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.27.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]

=QUERY(<\/span>A1:C4<\/span>, <\/span>“SELECT A, B, C, (C – B) WHERE (C – B) > 0 LABEL (C – B) ‘Oversold by’ “<\/span>, <\/span>1<\/span>)<\/span><\/p>[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]

Breakdown:<\/span><\/p>\n

    \n
  1. Data Range:<\/b> (A1:C4).<\/span><\/li>\n