View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default How can I use sumproduct with different size ranges?

It defeats the raison d' etre for SUMPRODUCT if you use arrays of
different lengths. Maybe there is a different function, but this
depends entirely on what you want to do.

HTH
Kostis Vezerides

On Dec 11, 1:49 pm, Fen wrote:
Is this possible or is there another function that I can use?

Thanks,