countif and date

  1. M

    Count Unique Values Based on Unique (sort of) Criteria

    Apologies if this question has been raised before, I did look through the old posts but nothing that got close to an answer for me. I need the count of how many times the ID occurs during a period. But I need to count them uniquely. Here is an example of the data Date ID 22/07/2024...
  2. Z

    Dynamic Reference with multiple criteria

    Hello everyone! I have a table that can have different number of rows whenever I update the data. What I need is to get a formula that can accommodate all available rows, i.e. today's file has 1000 rows vs. last week was 998 and maybe tomorrow is 1001. Another component of the formula is I need...
  3. S

    Countif with dates compared to two cells Sheets

    Hello I am really hoping someone on here can help, I am a bit of an excel/gsheet newbie... I am trying to create a TOTAL of actions overdue depending on the date. I have managed to use the COUNTIF function to count the dates that are overdue in column H. The next step is where I am stuck...
  4. S

    Count of Days per month for a contract period

    Hi All - I have a list of employees and their billing period against each contract. I need to calculate the days billed for each employee against each contract by month for last 12 months. My worksheet is as below: My expected result is as below: Thanks in advance. Regards, SSP
  5. D

    Conditional Formatting: Identifying duplicates and considering dates

    Hello all, I am trying to do conditional formatting to identify some emails based on how frequently they are on the sheet and when. I have the emails all listed in column H and dates listed in column B, data starts in row 2 for both. Basically I am trying to identify if an email pops up more...

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