Thanks:  0
Likes:  0

# Thread: SUM range ONLY if adjacent cell is not BLANK

1. ## SUM range ONLY if adjacent cell is not BLANK

Greetings. I have two columns of data. I want to sum up one column of numbers ONLY if the next to each number there is text in the column. If a number has no text in the adjacent cell, I want to ignore that cell's number in the total sum. Should I use SUMIF, and if so, how? Thanks!

2. ## Re: SUM range ONLY if adjacent cell is not BLANK

Try this where column B contains the values to sum and column A contains the cells that are text:

=Sumif(A:A,"<>"&"",B:B)

If you want it to be text and not numeric either then try:

=SUM(IF(ISTEXT(A1:A100),B1:B100,0))

Confirmed with control+shift+enter and not just enter.

Change column references as necessary. Hope that helps.

3. ## Re: SUM range ONLY if adjacent cell is not BLANK

Possibly

=SUMIF(A:A,"<>",B:B)

4. ## Re: SUM range ONLY if adjacent cell is not BLANK

Thank you both! That works like a champ. I actually tried the "<>" trick and couldn't get it to work. It works fine now. Thanks!

5. ## Re: SUM range ONLY if adjacent cell is not BLANK

 Hi, I would like to have the Colum "Total AB - Total CD" showing the result only in the cell showing data. Thank you very much, Aleks A B Total AB C D Total CD Total AB -Total CD \$1.00 \$1.00 \$1.00 \$1.00 \$1,210.44 \$1,211.44 \$164.00 \$1,375.44 \$347.48 \$1,027.96 \$225.00 \$226.00 \$164.00 \$1,191.96

## User Tag List

#### Posting Permissions

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