View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
WT WT is offline
external usenet poster
 
Posts: 16
Default Count and Sum function

I have a large range of data 37000 rows and multiple columns on a second
sheet that will vary in length more or less depending on the month.

I need to count the number of cells that contain the same value as in col A
but falls within a value between 0-50 in col b.

and then sum those same cells.

Obviously Sum and Count won't do this, please help.

Thanks in advance


--
Thank you