count occurences of one cell value in a range

Thanks for your reply. I can't seem to make it work, though - it returns weird values.

I guess it would have to be a way to recognize the value inside cell A756, for instance, and match each instance of that value to the "1" value in B2:B756? I'm very confused (

Yup, I can imagine I'm not putting it very clearly.

example.jpg

What I'd like to do is this: in column K I'd like to compute every time a title in column B (MAX81, PRO450 etc.) appears with a 1 value in the J column up to that moment. So K18, for instance, would tell me how many times MAX250 has appeared with a 1 value in the interval J2-J18.

Needless to say, this is in fact a huge table and each value in column B appears several times throughout the worksheet.

Thanks so much for taking the time. I'm so very lost here

Should this be working if I replace MAX250 with the cell location, like B16 or whatever? There are thousands of entries, and I'd rather the formula automatically recognized the B cell rather than I name the value...

I tried the formula and it keeps returning weird values - it returns a 0 value in a K cell right next to a 1 in the J cell, so something's now working right

Yay! I did the adjustments and it works!

Thanks so much!