Summary sheet returning #value!

[brian.baker13]

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

B45-B51 contains descriptions of lines codes such as KIT KAT CHUNKY
MEDIUM EGG 6X235G XB

When B45-b51 are empty there is a formula in the box i.e. =B11 in the
box which is pulling through from the top of the sheet but when there
is no data there B45 remains empty


The trouble is when B45 contains no description of linecode i.e. my
production plant has not run an item the summary table does not see
this as a blank or 0

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

Much Appreciated





Much Appreciated


Brian

 

[JE McGimpsey]

Perhaps you're "clearing" the cell using the spacebar, which inserts a
space character into the cell.

This may help:

=IF(LEN(TRIM($B45))=0,"",F11+...)


The other factor is that the #VALUE! error indicates you've got text in
your argument cells (F11, R11, ...) which return #VALUE! when used in a
math function.