Hi,

This isn't clear which column(s) must be the same as A. pehaps some sample
data would help.

Mike

"WT" wrote:

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