View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Sumproduct and filters

It might help if you tell us what you think your formula is attempting to
do.

--
Rick (MVP - Excel)


"Niller" wrote in message
...
Hi,
being quite new to the world of sumproducts I struggle to find a formula
that works when filtering.

The formular I am currently using is: =SUMPRODUKT($BJ$2:$BJ$462;BS2:BS462)

I'll be glad for any help.