SUM range ONLY if adjacent cell is not BLANK

[jkalpus]

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!

 

[schielrn]

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.

 

[barry houdini]

Possibly

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

 

[jkalpus]

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!

 

[Aleks14]

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

<tbody>
</tbody>