Search:

# MS Office Forum

Ask Question   UnAnswered
RSS Feeds

# How to add several conditions for formula "SUMIF"

Asked By: Klarissa    Date: Jan 02    Category: MS Office    Views: 2082

I want to sum the elements of one column under the two conditions.
The first and the second column contain different informations.
If the info is found in the the first column and if the other info
is found in the second column, then we add the elements located in
the third column, else, we continuous at the next line.

I've tried the formulas "sumif" but it does make only with one
condition.

Has anyone found the solution?

Share:

### 1 Answer Found

Answer #1    Answered By: Evan Jones     Answered On: Jan 02

What are the conditions?

=SUMPRODUCT(--(A1:A5>5),--(B1:B5<6),C1:C5)
in cell c6. In this case it totals the cells in C1:C5 as long as the
corresponding cell in columns A and B meet the folowing conditions:
The value in column  A should be greater than 5
The value in column B should be less than 6

Didn't find what you were looking for? Find more on How to add several conditions for formula "SUMIF" Or get search suggestion and latest updates.

Tagged: