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?
- formula help but not vba please
- Loop in formula
- Copy down formula with vba
- combining formula
- R1C1 Formula
- Paste Formula help
- VBA or array formula?
- searching within formulas
- Formula using range name in VBA code
- Three Leveled Formula
- VBA Formula prob
- Getting a formula to copy from inside VBA
- Populate Formula(Function) in rows
- Stuck on copying formula from 1 sheet
- Using an array formula as a hyperlink cell reference
- How to detect formula where it is refrering same row
- VBA Code for pasting a set of formulas down a data range
- Please Help me in this Formula
- VBA variable range in a formula
- Formula multiplying ActiveCell with "F11"
- copy down formulas in excel