C
C
Coder 14482020-05-24 18:45:14
excel
Coder 1448, 2020-05-24 18:45:14

How in a function, when a condition is met, sum only the element located in the cell with the same number?

https://drive.google.com/open?id=1ikthzFiSE-LxN5sI...
I need to sum only those cells in column "C" opposite which are cells on the left that contain the word "Russia". In the document that I attached, when at least one "Russia" is found, all the cells of the "C" column are summed up at once.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
John Smith, 2020-05-25
@wows15

=SUMIF(B3:B9;"Russia*";C3:C9)
if Excel is "Russian", then it will be SUMIF instead of SUMIF.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question