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

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.

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!!

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))

Thanks that worked great!!!