Results 1 to 5 of 5

Thread: If and function

  1. #1
    Join Date
    Nov 2005
    Posts
    3

    Unanswered: If and function

    I want to add column J which are values based on the following:

    ColumnB has certain text and ColumnE has certain text.

    Please help

    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy, and welcome to the board.

    When you say "join", do you want a space between them?

    For instance in J2, put this formula:

    =B2&E2 (without space)

    =B2&" "&E2 (with space)

    Copy/Fill down column J as needed.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Nov 2005
    Posts
    3

    If and functions

    Thanks for your post but i think i didn't post clearly


    ColumnB CoulmnC ColumnJ

    PA Paid 100
    PA Open 50
    NJ Paid 50
    PA Paid 75


    I want to add the values in Column J that have the conditions that in Column B say PA AND Column C say Paid

    Thanks for your help if you can help!!

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    Okay, with one condition you could use SUMIF, but with two conditions, you need SUMPRODUCT.

    =SUMPRODUCT(($B$1:$B$100="PA")*($C$1:$C$100="Paid" ),--($J$1:$J$100))
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Nov 2005
    Posts
    3

    Thumbs up If and functions

    Thanks that worked great!!!

Posting Permissions

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