View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
 
Posts: 270
Default Sumproduct again?

I have two ranges both of equal size; the first DU11:EL60 contains integers
ranging from 0 to about 60; the second range FE11:FV60 contains integers
ranging from 0 to about 25.
What I would like to do is count the number of values of 5 or less in the
first range when the corresponding cells in the second range is 0.
Sandy