ignore #n/a

  1. S

    Need bar chart to ignore entries with blank or #n/a labels

    Hello, I'm trying to build a chart that will ignore any rows of data that have a data label that is either blank or an error. I would use a pivot chart, but I need to be able to select from various metrics that are represented on the chart using a slicer. I've attached a link to sample of...
  2. R

    How do I Ignore #N/A with LINEST ? I have Partial Solution already...

    Hi, So I have two columns of data that I need to run a LINEST on, but these two columns will inevitabley have #N/A in some of their cells and there isnt anything I can do about this. That's fine, because I found a partial solution from a previous thread: LINEST question This works for the...
  3. B

    Ignore #N/A across information (SUMIF)?

    Hi, I have read how to ignore #N/A using sumif in another post but I don't think this will work in my case. I am trying to ignore all rows containing #N/A, not only the part of the formula containing the #N/A cell. I have a file I can upload with new data all the time so just filtering away...
    • bergen
    • Thread
    • discounts ignore #n/a ignore rows sumif sumproduct
    • Replies: 5
    • Forum: Excel Questions
  4. J

    How to ignore #N/A in the summation of a column

    Hello everybody. I am having a problem with a complicated workbook I have inherited at work. Currently, a cell with the formula =SUMIF(D$3:D$149,1,H$3:H$149) is returning a #N/A value because there are several #N/A cells in column H. How would I amend the formula to ignore any #N/A cells...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top