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