Trouble shooting#NA error in Array formula
 

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 worksheet named "Data" that hold my source data. I named two ranges
called "vendor" and value in this worksheet. I have another worksheet 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

Make sure that the ranges are the same size...

Hope this helps!

In article ,
"RonR" wrote:

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 worksheet named "Data" that hold my source data. I named two ranges
called "vendor" and value in this worksheet. I have another worksheet 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

And make sure that there are no #n/a's in either of your ranges.

RonR wrote:

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 worksheet named "Data" that hold my source data. I named two ranges
called "vendor" and value in this worksheet. I have another worksheet 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

--

Dave Peterson