Getting a SUM

Question

I am trying to SUM a column of tree rows with one of the rows showing a "NUM" result. This row may or may not be used so, if used, would contain a value and the SUM would contain all three rows. If the row containing the NUM value is not used the NUM is the result within the cell and the rows will not SUM. How do I SUM these rows with or without the NUM value?

Answer 1

You are welcome:) You may also give feedback on it.

Answer 2

How about

=SUM(IFERROR(range, 0))

If you do not have Microsoft 365, Office 2024 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.

Answer 3

Thank you, that worked!

Answer 4

=SUM(IFERROR(B2:B4,0))

Answer 5

5.0%	30	25	$500,000		$140,819	$32,526	$24,271	$8,255	$116,548
5.8%	15	14	$175,000		$16,809	$17,784	$15,887	$1,896	$921
0.0%	0	0	$0		$0	$0	#NUM!	#NUM!	#NUM!
				These are totals	$157,628	$50,310	$0 this is where I need the formula	$0	#NUM!

Hans,

First, thanks for the response.

Here is a portion of the workbook causing the issue. I am building this as a template so people can fill in numbers and have the calculations be completed.

I want the first two rows to SUM even with the #NUM in the third row. If the third row is used starting on the left side, a value will appear in the cell with the #NUM value. The cell returns a value when there is a valid number in the #NUM cell but not the way is is currently.