View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg
 
Posts: n/a
Default Sumproduct ?? Question

If you need to make several searches and
you want to save typing,
enter this formula below Countx:
=SUMPRODUCT((Type=TypeX R)*(ID=IDx R)*(Group=GroupX R))
Formula is in R1C1 style.
Arrange your search data this way and name it:
TypeX IDx GroupX Countx
A BOX017 S1 1
B BOX017 S1 2