This worked...

=SUMPRODUCT((M2:M10)="b")--SUMPRODUCT(--(F2:F100),--(F2:F10<=105))/COUNT(F2:F10)

"Rene" wrote:

David, your formula partially worked for me. Can I compute a percentage
instead of sum? SUMPRODUCT(--(B1:B1000),--(B1:B100<=100)/COUNT(B1:B100))

=SUMPRODUCT(((A1:A100)="B")*(B1:B100))

Thanks in advance.
Rene

"David Biddulph" wrote:

Not an IF statement, but:
=SUMPRODUCT((LEFT(A1:A100)="B")*(B1:B100))
--
David Biddulph

"grantr" wrote in message
...
Anyone know how to create an if statement that would say, if any cells in
the
column begin with B, sum the values in the column next to them.
--
grantr