ignore rows

  1. svendiamond

    Dynamic Named Range for a table? And not count entire column?

    Hello there! I have two questions. 1. Can I make a dynamic named range for a table? Not just one column? 2. Can I make the "Count" part not count the whole column? Because I have a row of "totals" I don't want to include in the range. I want to name the range from A1:O13 -- I want to name it...
  2. 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

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