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

Eugene2019-10-15 23:20:51

What engine does snik.co run on? 2Reply

T

TechNOIR2017-03-04 16:49:01

Powershell. How to append information to a file? 2Reply

R

Roman Romanov2019-07-31 18:29:43

How to use data from excel spreadsheets in python script? 4Reply

I

Igor Mamontov2021-03-04 13:07:14

How, when entering a value in an Excel table, compare it with the previous one? 1Reply

K

Kotar4ik2021-03-04 16:06:48

What is wrong with VBA macro processing cell array? 1Reply

Didn't find what you were looking for?

Ask your question