countif range

  1. K

    COUNFIF within a different sheet with dynamic range

    Hello, I have one excel file with several sheets of data and one final sheet XYZ dedicated for reporting. I have one sheet named ABC and there is a dynamic range which will change in the future - the number of columns can be different per each update of the file. I want to do a COUNTIF within...
    • kacper887
    • Thread
    • countif countif range dynamic column range dynamic ranges sheet
    • Replies: 1
    • Forum: Excel Questions
  2. M

    Complex, Countif 2 conditions met

    Hi All, I am looking to combined these two countif statements below to get a new =countif(Statement1 AND Statement2), I can't seem to figure out a formula that will work.. is this possible? Or is there a better way to do this? Statement 1 =COUNTIFS('Paste Key Survey Results'!F:F, "Yes")...
    • msiegal
    • Thread
    • complex countif countif countif 2 conditions met countif range countif this and that
    • Replies: 21
    • Forum: Excel Questions
  3. T

    countif help

    is there such a way to write a formula to count the number that are within 10% of a particular number or a number in a cell? thanks in advance

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