excel countif

  1. P

    Errin in function COUNTIF/COUNTIFS

    Hello, assuming you have classification characteristics in your master data and you would like to know how often a characteristic is assigned, then you use either the function COUNTIF or COUNTIFS. In this case, you will always get incorrect results if the classification characteristic was...
  2. R

    Count unique text to 1 number

    Hello people, I just gave up on trying to find a formula which I know must be easy. Here is the data I have (simplified data) (A, B, C and D are columns and the rows are A2 to A13 but my actual work would be for A2 to A1000 or better yet the whole All A column. A...
  3. P

    Excel - sequential numbering with countif

    Hope someoene can help with this. I have an excel sheet that I routinely import into Salesforce. The sheet is an extract from Sage containing data relating to Orders placed by Customers. Each row in the sheet contains an Order Number and order details. If an order comprised five items then...
  4. N

    Counting number of days for each employee since last day of absence/tardy

    I am trying to get the correct formula to count the number of days it has been for each employee since the last occurrence of an absence/tardy. For each employee, starting with the beginning of the year, we mark and employee as Absent as an "A" or Tardy as "T". See below the examples...

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