Results 1 to 9 of 9

If A1, A2, A3 = Hello then add B1, B2, B3

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2007
    Posts
    32

    If A1, A2, A3 = Hello then add B1, B2, B3

    Hello all,

    Is there a way to check all text values in Column A and if they are equal "Hello" or "Hello1" or "Hello2" then add all values in Column B and report it to Column c?

    for example
    A1, A2, A4 report "Hello", "Hello1", "Hello2". Now what I need is for excel to recognize the word "Hello" in all cells in Column A, then look at the value in column B, add them together then report it to a cell in column C. Below is a better example

    - |----A----|----B---|---C
    1 |-Hello--|---15--|-43
    2 |-Hello1-|---23--|
    3 |--Bye---|----1---|
    4 |-Hello2-|----5---|
    5 |--Bye1--|----8---|

    Thank you for any help
    Last edited by ADSK; 06-04-2009 at 01:14 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1