I
I
Ivan Erokhin2020-07-20 15:11:03
Google Sheets
Ivan Erokhin, 2020-07-20 15:11:03

How to find sum of values ​​in google spreadsheet by key?

There is such a table:
https://docs.google.com/spreadsheets/d/1GSUBEjnO0C...

In table 1, you need to find the sum of all values ​​​​from table 2 by "key"
5f1589ab3abf6559283527.png

I tried the lookup function + sum, but something like that Did not work out

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2020-07-20
@dero

Like this. Registered an example in your table
=СУММ(FILTER($F$2:$F;$D$2:$D=A3))

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question