| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulae to use for more that 2 conditions criteria
Hi,
May I know what is the best formula to use when there are more than 2 conditions need to be met? CAn I know how to use the Sum Product function? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulae to use for more that 2 conditions criteria
Take a look he
http://xldynamic.com/source/xld.SUMPRODUCT.html " wrote: Hi, May I know what is the best formula to use when there are more than 2 conditions need to be met? CAn I know how to use the Sum Product function? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulae to use for more that 2 conditions criteria
If you wish more than two criteria to be met, the AND function will combine
them. If you want to find out about any of the Excel functions, such as AND or SUMPRODUCT, try Excel's help. It includes examples for each. -- David Biddulph wrote in message ups.com... Hi, May I know what is the best formula to use when there are more than 2 conditions need to be met? CAn I know how to use the Sum Product function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
| Count if on Single Criteria with multiply conditions | Excel Worksheet Functions | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Linear Mode
