If your range with values possibly starting with B is A1:A10 and your range
with the values you want to sum is B1:B10 and you want the answer in C1 put
this formula in C1: =SUMIF(A1:A10,"B*",B1:B10) The formula is case
insensitive - B = b.

tyro

"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