countifs exclude

  1. G

    count cells that string contains X but does not contains Y or Z

    Hi, sooo..... I have list in table 1 (below) and I want to count in table 2, the number times the text in table 2 column A appear in the list from table 1. BUT i need to to exclude any entries that are in A4 or A5 from table2. I can do count if but i cant figure out how to exclude. for the...
    • gaz_11
    • Thread
    • count countif countifs exclude exclude table
    • Replies: 7
    • Forum: Excel Questions
  2. D

    Countifs exclude based on other criteria

    I have a data set where I am using a "countifs" function to count entries based on ID and date range. I need to integrate another data set with a unique format, but some of the same columns, and then ONLY count unique entries based on ID, date range, and exclude entries based on a third...

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