View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
kristenb via OfficeKB.com kristenb via OfficeKB.com is offline
external usenet poster
 
Posts: 2
Default Sum Cell Values of one column based on Another Cell Value in a different column

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