There are four columns

ABCD

Column D contains numbers.

How to create a formula: if in column A we find HELLO , in column B we find BYE , in column C we find YES , then sum up what is in column D

Those. you need to check three conditions at once that will be summed up.

  • The questions are a little different, but considering that the author is the same and the function is the same - double ru.stackoverflow.com/questions/839763/… - vikttur
  • Possible duplicate question: OpenOffice: add another value in the formula for the amount of the conditions - vikttur
  • I think the question is not the same, since one column should be summed up by 3 values, but it seems to count 2 times (if you use + SUMIFS), ie, I have 3 values ​​in a row, so if these three values ​​match the condition, then you need This is to contribute to the total amount. In the example that you indicated, a little bit wrong (it is summed up under two different conditions that are in the select) in this case they are in different columns - webstackoverload
  • There, the data of column F are summed up according to the conditions of columns H and G. The SUM is used only for summation over different values ​​of G. It is not needed here. Use SUMIFS by adding a condition on the third column - vikttur
  • Confused in the answer, can you give an example? - webstackoverload

1 answer 1

=SUMIFS(D2:D9;A2:A9;"HELLO";B2:B9;"BYE";C2:C9;"YES") =СУММЕСЛИМН(D2:D9;A2:A9;"HELLO";B2:B9;"BYE";C2:C9;"YES")