countif

  1. J

    How to create a dynamic rolling count by year column

    Hi, I am trying to do a few things based on the below sheet. Essentially I have a long sheet of dates broken down by year ,month ,day hour...etc. I aim to have a rolling count of the total number of rows for each year. So column "percentcounter is an example of what I would expect to see. It...
  2. Jyggalag

    COUNTIFS formula not working

    Hi all! I am currently comparing values in two sheets to each other to see if they are similar or dissimilar. I have this setup at the moment: My formula is: =IF(COUNTIFS('[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$T$2:$T$1712;E2;'[CONFIDENTIAL - NUMBER.xlsx]Sheet1'!$R$2:$R$1712;A2)=1;"yes";"no")...
  3. F

    Countif when a cell in the row contains a date within the last 90 days

    I need to count all specific values in column B, only when column A contains a date within the last 90 days. Can anyone assist me with this?
  4. R

    Count nonblank cells except with certain criteria

    Hi, I'm trying to create a new rota for my workplace [Google Sheets – image below- Column D needs to be a total number of nonblank cells, but only if they're not any of SICK, HOL, SAB, OFF, MAT, PAT, R/O. (So in that image, it would just be 4). I'm currently using...
  5. C

    CONCAT cell reference

    Cells A-H in blue refer to workbook 'Dan Participants'. Columns A and B are linked to an external data source. I have used the CONCAT function to merge the names together from cell A and B. Cell H references the internal worksheet 'Vacancies', cells C and K coloured red. The formula works as...
  6. B

    Count Text String Occurrence Across 2 Column Array But Only Count Text String Once if in Adjacent Cell

    I have a data table with multiple columns. I need to count the number of occurrences of names in the range --> Summary!$C$3:$D$10000. The name list is located on Sheet1!$A$2:$A$8 I want the total count to be Sheet1!$B$2:$B$8 If the same name is shown in the adjacent column cell, I only want to...
  7. Jyggalag

    How to use OR formula in Excel correctly? With IF and LEFT

    Hi all, I am currently trying out this formula: Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!") Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...
  8. Chris_010101

    Formula for returning last date

    Hello I'll try and keep this simple. Sheet 1 This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row. On each occasion, there is an absence start date and an absence end date. Example: an employee with 2 separate...
  9. M

    Create a count of Cells of different colors

    I am attempting to count the number of cells in column A that are formatted with different colors (Green, Yellow, Blue, Orange, empty, etc.) and place the total in column M. I have tried =countIf( ...) and many others. Is there a Filter command I can use? Any advice is welcome. I thought...
  10. sakis_s

    COUNTIF with multiple criteria

    Hi! I'm trying to create a folrmula to search in different columns and if all cretiria match, then it will return the result. For example: A B C D E F G 1 kids cushioned sportive socks 2p kids socks 2p 2 pack socks for kids If B1 contains all word cretiria from columns D,E,F...
  11. M

    Copy and Paste Macro Based on Matching Values Not Doing Anything

    I have 2 sheets, Sheet1 and Summary. In Sheet1, the first row contains text that may or may not be contained in column C of Summary. I am trying to copy and paste the values in Summary's column D alongside column C matches to Sheet1's first row (the data in Summary is already grouped by column...
  12. R

    Hello friends. Please help ! COUNTIF formula ?

    Hello friends. Please help ! I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12" and "F3:F12". But to count only in the first 5 cells with value (that are NOT empty blank cells). I don't want to count all "W" and "D" and "L"...
  13. I

    Search columns by a specific text and use countif

    Hello, I am looking a solution for this: 1. I need to define a specific text in row (not each column), for example: "STAT" 2. Use function countif on value below (Cpk) - row Nr 24 3. Do some popup window where will be a result "Values Cpk > 1,33 : NUMBER , Values Cpk < 1,33 : NUMBER" I need...
  14. M

    Need help getting count if "all continents" are selected in dropdown and counts

    Hi everyone. I hope you are doing well. I am having some trouble returning all values in a data set in a dropdown for a graph. I am attempting to build an excel formula using COUNTIF and embed syntax in there that if I select "All continents" for example in the dropdown it will return all values...
  15. D

    COUNTIF w/ greater than & name match

    I am needing to COUNTIF column B on "Data" sheet is greater than column C on "Data" sheet, if the name in column A of "Totals" sheet matches the name from column A on "Data" sheet. The Data sheet has multiple rows with the same name that need to have the values in B and C checked. Data Sheet...
  16. G

    Countif border of a cell is red

    Hey everyone, this should be an easy one for someone. I just need a simple code to count how many cells in a range (E26:BD26) have a red top border. I’ve found threads on changing border colors, counting by cell value, etc. But I just want to count red borders. 1 cell returns a value of .25 (I’m...
  17. T

    Rank a subset with duplicated values defined by another column

    Hello, I'm trying to create a column with a rank of values based on a control column. I've posted this in StackOverflow but I feel this forum is more appropriate for the topic. My data: (A) (B) (C) Value Control Rank 100 1 8 200 1 6 200 1 7 300 0...
  18. Z

    Count the unique IDs for a table

    Hi, I have the sample table below and what I need to count: the total unique EEID that their type is R ABCDEFGH1EEIDTypeQuestionsStatusResults2611RQ1Completedis to count how many EEID that their Type is R and Completed the Q463611RQ2Completedtotal of unique EEID that their type is...
  19. A

    countif range from reference cell

    hello, i want to do countif function and in the range of the function i want to put cell H4 whice contains - "sheet3!AR2:AR72" so that the countif will go to sheet3 to coulmn AR. how can i do that?
  20. S

    TRUNC function in COUNTIF or COUNTIFS produce error message

    Hello, Would you know why the usage of a TRUNC function into COUNTIF our COUNTIFS, as here-after, produce the following error message ? =COUNTIF(TRUNC($A$2:$A$6),D$1) The range $A$2:$A$6 contains some numbers with decimals and I aim to count how many of them matches the cell D1 that contains...

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