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?

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?

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?