Answer the question
In order to leave comments, you need to log in
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
=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 questionAsk a Question
731 491 924 answers to any question