SUM in column with #N/A showing

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel - 19 Jun 2007 17:13 GMT

Hi

I have Excel 2003, I have a spreadsheet where the intent is to load various
formulae
and have them costed, there are 30 rows but not all are used each time.
I have a VLOOKUP reporting the cost to a column where I need to total the
cost
but the SUM reports #N/A unless I have each row filled and a cost showing in
each cell.

How can I overcome this?

thanks

Daniel

Reply to this Message

Dave Peterson - 19 Jun 2007 18:31 GMT

Maybe you could use a formula like:

=SUMIF(a1:a30,"<>#n/a")

or change the =vlookup() to hide those errors:

=if(isna(vlookup(...)),"",vlookup(...))

> Hi
>
[quoted text clipped - 11 lines]
>
> Daniel

Signature

Dave Peterson

Reply to this Message

Daniel - 19 Jun 2007 18:51 GMT

Dave

that did it, I used the first one.

thanks for your help

regards

Daniel

> Maybe you could use a formula like:
>
[quoted text clipped - 21 lines]
>>
>> Daniel

Reply to this Message

Rate this thread: