Summary Sheet Returning #value!

[brian.baker13]

Hi

I have a summary table running using this formula:
=IF($B45="","",F11+R11+AD11+AP11+BB11+BN11+BZ11)

B45-B51 contains linecodes for items such as 12021756, there are then
other vlooks running.

When B45-b51 are empty there is a 0 in the box which is pulled through
from another sheet.

The trouble is when a 0 is looked up and the accompanying row is empty
of data i.e F11+R11... I get a #value! error which spoils the summary.

When B45 contains a 0 i want a 0 to appear in my summary box so the
formula will work..

Much Appreciated

Brian

 

[Peo Sjoblom]

There is no way you can get a value error unless you calculate with text so
the empty data must be either a space or a null string ""

you can use


=IF($B45="","",N(F11)+N(R11)+N(AD11)+and so on

or


=IF($B45="","",SUM(F11,R11,AD11,and so on



--


Regards,


Peo Sjoblom