| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Sum If with two or more conditions
Hello!
I've tried to make a sum if iwth two conditions, but i am thinking wrong. What I need is a formula to make the Following: Columns: A B C D Product QTD Product QTD If on the range A finds anything that matches with range C, then Subtract D-B Is this possible? Thanks In advance. RS |
|
#2
|
|||
|
|||
|
One way:
=SUMPRODUCT(--(A1:A100=C1:C100),D1:D100-B1:B100) In article , (Ruben Silva) wrote: Hello! I've tried to make a sum if iwth two conditions, but i am thinking wrong. What I need is a formula to make the Following: Columns: A B C D Product QTD Product QTD If on the range A finds anything that matches with range C, then Subtract D-B Is this possible? Thanks In advance. RS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
| average on 2 conditions | Excel Worksheet Functions | |||
| How can I use COUNTIF to sum for two conditions? | Excel Worksheet Functions | |||
| Summarize data with multiple conditions | Excel Discussion (Misc queries) | |||
| Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
Hybrid Mode
