| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array Formula | Excel Worksheet Functions | |||
| How can I use a cell reference in Sumproduct array formula? | Excel Discussion (Misc queries) | |||
| Array formula that alphabetizes a list | Excel Worksheet Functions | |||
| Array formula reference (Corrected) | Excel Discussion (Misc queries) | |||
| Array Formula | Excel Worksheet Functions | |||
Linear Mode
