How to find values by pattern and get the sum of values from cells?

A

Alexey Golovin2022-01-28 08:36:12

Google Sheets

Alexey Golovin, 2022-01-28 08:36:12

Hey! There is a table. In column A, serial numbers like 1.1, 1.2...2.2, 2.1, ... 15.1, etc. Column D has values.
How to find all values from column A for sequence numbers 2.* and get the sum of values from the same rows from column D?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander, 2022-01-28
@dadduUrsa

SUMIF (SUMIF) with wildcard in condition:=SUMIF(A2:A;"2.*";B2:B)