How to group data in excel?

U

Uber Noob2019-03-22 07:03:13

excel

Uber Noob, 2019-03-22 07:03:13

There are 4 lines, 2 columns for example:
A | 20
A | 20
B | 30
B | 30
I would like to get the amount grouped by the first column:
A | 40
B | 60
I know how to do it in MySQL, but I don't know how to do it in excel )) Can someone tell me?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Anton Fedoryan, 2019-03-22
@ubernoob

SUMIF

Similar questions

E

Evgenu2017-08-17 14:43:49

How to organize the introduction of data from users into the database? 0Reply

A

Andrey Perevozchikov2020-01-25 18:19:39

How to add the coordinates of the settlements to the table and pull up (to the next cell) the description from the pdf book? 1Reply

M

Max2020-01-27 14:17:25

How to make a new table by copying the necessary rows from the finished table? 1Reply

S

Sergey Zolotarev2020-01-31 18:55:05

How to replace the current numeric date with the name of the current day, the current day, the month in words and the year using the TODAY() function? 2Reply

N

nikitoshq2020-02-06 15:59:49

How to write data to excel file in PHP? 1Reply

Didn't find what you were looking for?

Ask your question