View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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?