RE: SUMPRODUCT

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks bj,

What I get with both of these is"0".

Jim

"bj" wrote:

> is it just the AN column array you are having problems with, or the full
> equation?
> try a
> =sumproduct(--iserror([Data.xls]A!$AN$2:$AN$5000))
> if you get a 1 try
> =sumproduct(--iserror([Data.xls]A!$AN$2:$AN$5000),row(([Data.xls]A!$AN$2:$AN$5000))
> if you get more that 1 try reducing the range until you do get 1
>
> "Jimbo" wrote:
>
> > Greetings,
> > I’m looking for an explanation for something happening in Excel that I don’t
> > understand. In a worksheet cell I have a formula
> > “=SUMPRODUCT(--([Data.xls]A!$H$2:$H$5000=”Asia”),--([Data.xls]A!$AN$2:$AN$5000))”
> > which works fine. Regardless of how I try to do it, I can’t copy it to any
> > cell on any other worksheet without an error “#VALUE!” rising from the
> > “--([Data.xls]A!$AN$2:$AN$5000))” array. I don’t understand why I get an
> > error when I know the formula works fine.
> > Appreciate whatever help you can give me!
> > Jim
> >
.

Relevant Pages

  • Re: How To Compare Date with Just the Day of Month
    ... regardless of the time of day. ... use trunctrunc on a date removes the fraction of a day and ... Jim ... Prev by Date: ...
    (comp.databases.oracle.server)
  • RE: SUMPRODUCT
    ... is it just the AN column array you are having problems with, ... In a worksheet cell I have a formula ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: POLL: Giambi - Juiced or Not?
    ... > This is regardless of whether or not it's been proven, ... > just your own speculation, no more, no less. ... Jim ... Prev by Date: ...
    (alt.sports.baseball.bos-redsox)
  • Re: My whinge to Pacific.......
    ... > regardless of whether there's any new chat or not. ... Prev by Date: ...
    (rec.gambling.poker)
  • Re: Problem with transport??? Received date not registered on saved message.
    ... Jim ... >> The problem is that the Category dialog comes up regardless of the ... > fldDestination is a MAPIFolder object, ... >> executes if there is a value for this variable ...
    (microsoft.public.outlook.program_vba)