if you are limiting this to when the cell in column contains ONLY a B, then

=sumif(F7:F100,"B",E7:E100)

if you want to sum when column F BEGINS with B, then

=sumif(F7:F100,"B*",E7:E100)

and if you want to sum anytime column F contains a B anywhere in the cell

=sumif(F7:F100,"*B*",E7:E100)



"kristenb via OfficeKB.com" wrote:

Hi All!

I need to place the sum of certain cell values in a separate cell. Easy
enough, except for one thing:

Here's the deal. If F21 has "B" in it, that's when I need E21's value added.
If there is ANYTHING else in column F, don't add the value of the
corresponding E column cell. I would like a function formula that I will
place in E6 that will work for the entire columns E & F.

Let me know if you need additional information to understand my query.

Thank you!
Kristen

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200802/1