How to check for 2 conditions?

Question

excel

Help with formula.
Here is the working formula: =СУММЕСЛИ(C:C;"Текст1";H:H)
But how to check for 2 conditions, "Text1" and "Text2"?

Answer 1

The question is poorly worded.

how to check for 2 conditions, "Text1" and "Text2"

The value in a particular cell cannot be both "Text1" and "Text2" at the same time. Without the use of telepathy, the question can be understood in two ways:
1) "Text1" must be in column C and at the same time "Text2" must be in column D. Then the answer: https://exceltable.com/funkcii-excel/funkciya-summ...

=СУММЕСЛИМН(H1:H100;C1:C100;"Текст1";D1:D100;"Текст2")

2) It was meant not AND, but OR, i.e. sum when the value in column C is "Text1" or "Text2".
Then like this:

=СУММЕСЛИ(C1:C100;"Текст1";H1:H100)+СУММЕСЛИ(C1:C100;"Текст2";H1:H100)

PS Sergey Sergey , in SUMMESLI there is simply nowhere to shove logical operators, there are no boolean type arguments, unlike the IF function.