Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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?

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.

Related Topics:

- VBA code to add values in two cells which have formulas
- Excel 2000 Sumif/Countif
- Using a Defined Variable Range in a VBA SumIf
- clearing cells value without deleting the formula I've made in cell from excel formula , HOW?
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Populate Formula(Function) in rows
- searching within formulas
- Formula using range name in VBA code
- Three Leveled Formula
- R1C1 Formula
- Paste Formula help
- VBA or array formula?
- combining formula
- formula help but not vba please
- Loop in formula
- Copy down formula with vba
- Array Formula
- Ctrl+Shift+Arrow Fails To Select Cells When Used in Formula Bar
- Stuck on copying formula from 1 sheet to another
- Named formula/Windows dialog boxes
- cells containing formula that refer to user-defined VBA function
- sum formula
- Manually creating a row outline with no formula anywhere
- Blank Formula bar