Q207 is the problem

[Pat]

The following is a simple enough formula except Q207 value is the result of
a formula. Sometimes Q207 does not return a value which results in the
following formula not returning a result either. All other cells in the
range will have a value except for Q207


AI207 =Q207+R207+AF207+AE207+AA207

The error #VALUE! returns, is there a way round returning the result of all
other cells in the range if Q207 has non to return?

Much appreciate any help.
Pat

 

[Peo Sjoblom]

You can use

=SUM(Q207,R207,AF207,AE207,AA207)

which will ignore text (I assume that when Q207 does not have a value it is
"" which is text and thus the error)


Regards,

Peo Sjoblom

 

[Trevor Shuttleworth]

Pat

untested but you could try:

AI207 =IF(ISERROR(Q207),0,Q207)+R207+AF207+AE207+AA207

Regards

Trevor