sumproduct, lookup?
 

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!

sumproduct, lookup?
 

What calculation do you want to perform on the row once you identify it?

Tom

sumproduct, lookup?
 

I want to calculate the percentage for when "b" apears in M2:M10
=SUMPRODUCT(--(B2:L100),--(B2:L10<=105)/COUNT(B2:L10))

a1 b2 c2 m2
111 b
99 s
200 s
110 b
50 b
99 s
225 b
b % = 25% (0 and <=105 b2:l10)


"TomPl" wrote:

What calculation do you want to perform on the row once you identify it?

Tom