Formula Error

[Vicki]

Here is what I have in the cell (D372)
=IF(M37+M40>0,"X","")

What I am trying to do is if M37 and/or M40 has number great than 0 to put
an X in cell D372.

And also in other cells I have ones like this
In cell D371
=IF(K4+K10+K13+K16+K19+K22+K25+K28+K31+K34+K37+K40>0,"X","")
What I'm trying to do here in cell D371 if any of these cells has an X then
put an X in cell D371

I am getting a #value! error on both D372 and D371

Any help is very much appreciated!

 

[Stefi]

=IF(M37+M40>0,"X","") gives a #value! error if any of the cells to be summed
up contains non-numeric data. Decide what to do in this case!

Use this formula in D371 for putting X in it in case of any of K4,K10, ...
cells has an X in them:
=IF(SUM(K4="X",K10="X",K13="X",K16="X",K19="X",K22="X",K25="X",K28="X",K31="X",K34="X",K37="X",K40="X")>0,"X","")

Regards,
Stefi

„Vicki†ezt írta: