Y
Y
YeaNot2021-07-20 14:37:16
excel
YeaNot, 2021-07-20 14:37:16

How to find the sum of numbers in one column in Excel, respectively. whose cells in the neighboring one fit the criterion?

In the left column in each cell there are words separated by commas, in the right in each cell there is one number:
60f6b79974f13538590589.png
You need to find the sum of the numbers from the right column, the corresponding cells of which from the left column contain a certain word, through the formula. For example, in the image for the word "one" the sum will be equal to 20.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
John Smith, 2021-07-20
@YeaNot

UPD
60f6cba6e8e2c104169635.jpeg
=========
Below is an old wrong answer, not taking into account that a line can contain not only "one", but also, for example, eleven, as @Akina rightly noted

old answer
Можно через SUMIF (СУММЕСЛИ):
60f6be36e5eee642725177.jpeg
Можно через функцию DSUM
60f6be4acf331547612565.png

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question