How to google tables to group data by value in a column?

Try so

= QUERY (Data! $ A $ 2: $ A $ 1000; "select A, SUM (A) group by A")

PS: google search did not help, there is a grouping in standard excel (not online), and there are some strange ways in the online version. Maybe there is some kind of permission or formula?

    1 answer 1

    Judging from the condition, the following result will be obtained (using the example of Google Таблицы ): Initial data (sheet name Лист1 ):

    Initial data

    Result of grouping:

    Result of grouping

    1st method:

    1. use the function SUMIF ( SUMIF ), which finds the sum of the contents of cells that meet a specific condition;
    2. For the grouping and summation of the Значения by 1 column, the following formula would be =sumif(A2:A9;C2;A2:A9) , where

    2.1. A2:A9 - the диапазон in which the search for cells that satisfy the condition;

    2.2. C2 is a condition for searching for cells in a диапазоне . In our case, 1 ;

    2.3. A2: A9 - the range, the cells of which are summarized.

    Grouping formula Google SUMIF () Help

    2nd method:

    1. Use Сводные таблицы .
    2. Select the menu item Данные - Сводная таблица ;

    3. Creating a pivot sheet Сводная таблица ... Summary table

    4. In the Редакторе отчетов add:

    6.1. In the Строки category, the column name Значения (Sheet Лист1 );

    6.2. in the Значения category, the Значения field (sheet Лист1 ) (coincidence name ( Значения ) of category and column names). The default setting is SUM (summation of values). We get the result enter image description here

    Help on creating a PivotTable by Google

    • I didn’t particularly understand the answer, since I had been writing a question for a long time, but I’d probably note how correct the person tried to write =) I decided through highlighting and some other conditions putting the data in a separate column using formulas. I don't remember which ones anymore - Serge Esmanovich