Trouble shooting#NA error in Array formula
- From: "RonR" <RonR@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Jun 2005 08:36:03 -0700
I'm receiving a #NA in a array formula that I have used successfully on a
weekly basis for the past 2 years. Today, however, I'm receiving the #NA
error.
I have a work*** named "Data" that hold my source data. I named two ranges
called "vendor" and value in this work***. I have another work*** that
has the array formula "={sum((vendor=Acer)*(value))}". For some reason I'm
getting #NA today and have no idea why. Can anyone help me solve this
problem?
Thanks,
Perplexed in Miami
.
- Follow-Ups:
- Re: Trouble shooting#NA error in Array formula
- From: Dave Peterson
- Re: Trouble shooting#NA error in Array formula
- From: Domenic
- Re: Trouble shooting#NA error in Array formula
- Prev by Date: Re: Relative reference autofill increment other than +1
- Next by Date: Re: Automatic Insert Row & Carriage Return
- Previous by thread: Sort by IP
- Next by thread: Re: Trouble shooting#NA error in Array formula
- Index(es):