Help with Formula!!

[Formula_Newbie]

I need help with a formula that says if a single cell within these ranges contain a negative number return 0 or don't add, and if all the cells are positive numbers, then sum. For example, A6:A8 has a negative number in one of the cells, therefore I just want the result to be zero, instead of 14.65. Your help will be much appreciated!!

 

[Fluff]

Hi & welcome to MrExcel
How about

=IF(MIN(A6:A8)<0,0,SUM(A6:A8))

 

[Formula_Newbie]

Hi & welcome to MrExcel
How about

=IF(MIN(A6:A8)<0,0,SUM(A6:A8))

That worked! Thank you so so much!

 

[Fluff]

You're welcome & thanks for the feedback.