View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LisaM LisaM is offline
external usenet poster
 
Posts: 24
Default Sumproduct(match range of values in 2+ cols)

I've just double checked this further and it doesn't work. Where it did was
due to luck or chance rather than a properly-functioning formula...

"LisaM" wrote:

It appears to work if I use only one ISNUMBER(MATCH argument,
not with two or more.