Summary sheet returning #value!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brian.baker13@googlemail.com - 13 Nov 2007 17:06 GMT

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

Reply to this Message

JE McGimpsey - 13 Nov 2007 17:43 GMT

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.

> have a summary table running using this formula:
> =IF($B45="","",F11+R11+AD11+AP11+BB11+BN11+BZ11); copied down several
[quoted text clipped - 20 lines]
>
> Brian

Reply to this Message

Rate this thread: