Summary Sheet Returning #value!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brian.baker13@googlemail.com - 13 Nov 2007 16:57 GMT

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

Reply to this Message

Peo Sjoblom - 13 Nov 2007 17:18 GMT

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

Signature

Regards,

Peo Sjoblom

> Hi
>
[quoted text clipped - 16 lines]
>
> Brian

Reply to this Message

Rate this thread: