Simple calculation does not complete properly

[DORAMIUS]

I have a workbook with 13 sheets: Annual, Jan-Dec
Annual is the First sheet:
B9 is =SUM(Jan:Dec!B9) [value appears as $600.75]
B12 is 13,000
B13 is $0.585
B14 is =SUM(B12*B13)
B17 is =SUM(Jan:Dec!B22) [value appears as $1981.00]
E8 is =SUM(Jan:Dec!E2) [value appears as $5160]
E13 is =SUM(Jan:Dec!E10) [value appears as $2,905]
E17 is =SUM(Jan:Dec!E16) [value appears as $960.00]

I'm having a problem with the following not getting any values. Removing B14 from the formula seems to fix everything. Is there another equation/formula I should be using?
E14 is =SUM(B14+E13)
B22 is =SUM(B9+B14+B17+E8+E14+E17)

This seems like it should be so simple, but I can't figure out why it keeps breaking. I keep trying to search for a fix, but I must not be using the proper search term because I just find basic math calculation and order of operations information.

 

[RoryA]

What exactly does "not getting any values" mean?

Also, you don't need to use SUM with your multiplication, nor do you need both SUM and +

B14 can just be =B12*B13
E14 can be =SUM(B14,E13) or =B14+E13
B22 can be =SUM(B9,B14,B17,E8,E14,E17) or =B9+B14+B17+E8+E14+E17

SUM is often a better option than + because it will ignore any text values.

 

[DORAMIUS]

What exactly does "not getting any values" mean?

Also, you don't need to use SUM with your multiplication, nor do you need both SUM and +

B14 can just be =B12*B13
E14 can be =SUM(B14,E13) or =B14+E13
B22 can be =SUM(B9,B14,B17,E8,E14,E17) or =B9+B14+B17+E8+E14+E17

SUM is often a better option than + because it will ignore any text values.

Hi Rory. I'm sorry. I'm getting a null or error value in specific fields that should be populating a result of calculations. I trimmed up my values for the below cells, but the function of the cells should remain the same. I'm still getting an error at B22. I was able to adjust some calculations in other cells to remove B14 from the string in B22, but I still am getting an error value in B22. I should be showing a value of 19,211.75. Is my cell string too long with other cells that have formulas in them. I'm pretty sure I've never had this before with more complex cell formula strings.

B14 is =B12*B13
B22 is =B9+B17+E8+E14+17

 

[rakesh seebaruth]

E14 is =SUM(IFERROR(B14,0)+E13)
B22 is =SUM(IFERROR(B9,0)+IFERROR(B14,0)+IFERROR(B17,0)+IFERROR(E8,0)+IFERROR(E14,0)+IFERROR(E17,0))

 

[RoryA]

If you're getting an error with =B9+B17+E8+E14+17 then one or more of those cells contains something that is not, and cannot be converted to, a number.

 

[DORAMIUS]

Hi Rakesh. That seems to have fixed the issue, although I had to remove B14, because I had made a different adjustment. Not sure why it was having an issue, as you're formula is just doing a check for error, but is essentially, the same.