Wrong formula

[Blackwell]

I have this formula and I cannot get it to work for me
=IF(E11="",0,SUM(F6:M6,B11:E11)) the cell which the formula is in is E15, so if E11 has no value then I want E15 to be "0",,
If E11 has a value then the formual SUM(F6:M6,B11:E11) needs to apply. Thank you.

E6 5,000
E11 0
E15 0

E6 5,000
E11 4,000
E15 9,000

 

[Marcílio_Lobão]

Blackwell, Good afternoon.

Are you sure your information is CORRECT?

Formula range don't match with your cell reference displayed.

 

[Blackwell]

Hi, Yes the information is correct
F6:M6 = 60,000
B11:E11 16,500

I have tried to input the info on the spreadsheet but it goes haywire.
I am trying to complete a VAT threshold for my son business, which picks up Aug 2017 to Mar 2018 and then adds Apr to Jul
So E6 will have 5,000
E11 may have a value or not in this case 0
E15 will pick up the formula, but if E11 has no value for the month I want E15 to be 0.
I hope this is clearer, hopefully. Thank you.

 

[Toadstool]

I think you need to change the first SUM range from =IF(E11="",0,SUM(F6:M6,B11:E11)) to =IF(E11="",0,SUM(E6:M6,B11:E11))
because the range you have isn't adding in the 5,000 in E6

<img src="http://i63.tinypic.com/34gvvk3.jpg" border="0" alt="Image and video hosting by TinyPic">

 

[Blackwell]

I think you need to change the first SUM range from =IF(E11="",0,SUM(F6:M6,B11:E11)) to =IF(E11="",0,SUM(E6:M6,B11:E11))
because the range you have isn't adding in the 5,000 in E6

<img src="http://i63.tinypic.com/34gvvk3.jpg" border="0" alt="Image and video hosting by TinyPic">

Hi, Thank you I will amend.