why isnt this "IF" formula working? Sum a range greater than zero, give * result

[Marq]

I put this formula in cell N406

=IF(D407:D420>0,"*",0)

My range of D407:D420 is greater than zero...so why isn't an * showing up in the cell N406?

My sum in the range is 13..so I should expect to see an asterisk, correct? Should it be something other than an "IF" formula?

 

[DanteAmor]

Try

=IF(SUM(D407:D420)>0,"*",0)

 

[AlanY]

you're checking a range not a single cell thus need an array formula,

try to confirm the formula with
shift-control-enter all 2 together

 

[kweaver]

Your formula compares the contents of the cells to 0 rather than the sum of the range.

 

[Marq]

Try

=IF(SUM(D407:D420)>0,"*",0)

yep..that works..thanks

 

[DanteAmor]

yep..that works..thanks

I'm glad to help you. Thanks for the feedback.