Trouble shooting#NA error in Array formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ignore #NA in average formula 2
Redefine range of cells, array formula returns NA 4
Vlookup Match BUT Returning #NA 1
Problems with Array Formula - 2 data criteria 2
#NA error 2
Min in array formula 2
Word Using the 'IF' Formula in MS Word 2010 0
#NA error 7

Back
Top