Hello. I am trying to avoid entering data on two different worksheets.

=SUMPRODUCT(--(B2:B100),--(B2:B10<=105)/COUNT(B2:B10))

How do I write the formula to look in column M for "b" then compute the
sumproduct formula for that row? I want to avoid adding more columns to the
worksheet.

Thanks for your help. I am learning so much from this board!