Tag: countif

6 Count unique value ignoring Text in range 2018-06-22T07:16:05.760

5 Excel: Counting number of MAX values in a range 2012-01-13T13:36:14.217

5 Excel Countif 0, 00, 000 separate entries 2015-10-21T06:37:14.733

4 check two conditions in two different columns in excel and count the matches 2012-10-07T18:23:23.973

4 Excel countif doesn't work with numbers 2013-07-09T08:37:08.933

3 excel countif filtered by style 2012-04-18T02:06:18.300

3 Include an OR condition in a COUNTIF? 2013-05-01T16:03:12.773

3 Count first occurrence of one criterion based on a second criterion 2014-01-17T15:43:40.147

3 =countif says "0001234" is not equal to "0001234" How to force countif to treat strings as text not numbers? 2016-08-30T16:13:25.303

2 Excel COUNTIF Statement 2012-05-24T18:05:53.230

2 How to use countif, sumif across two sheets where the logical test is an equivalency? 2012-09-24T14:32:40.040

2 Count value between 2 date ranges 2012-12-03T18:49:37.350

2 MS Excel: Count frequency of similar values in between blank cells 2014-09-02T21:53:34.773

2 Using COUNTIF in Excel to count number of "Greater than" values in an array of values 2014-12-31T18:04:37.287

2 How do I count multiple words available in sentences and multiple rows (countif, search)? 2015-01-30T03:19:01.543

2 Excel: count number of unique matches for multiple criteria 2015-05-15T21:25:28.460

2 How to count the number of cells in a range containing a specific (sub)string with Excel/Calc? 2016-06-30T22:03:00.870

2 CTRL+SHFT+ENTER Array Formula not working 2017-11-09T23:24:46.333

2 Advanced sumproduct 2017-12-27T16:23:24.747

2 Display the lines that meet the COUNTIF criteria 2018-01-11T18:05:46.047

2 How to Count Unique Dates for a Given Year in Excel 2018-07-27T19:19:51.323

2 How to count cells if it contains a value in Excel 2019-01-15T11:40:07.240

1 Custom function COUNTIFUNIQUES in Excel 2013-02-05T14:19:18.277

1 Excel: Reference Dropdown Cell in Countif Formula 2014-02-24T00:38:45.427

1 Excel count all rows that contain certain values for certain fields 2014-03-04T17:44:44.537

1 How to count unique numbers based on month? 2014-08-07T03:05:13.883

1 Advanced data consolidation in Excel 2015-01-17T01:54:57.127

1 Excel: How to count cells, whose date values represent a day between monday and friday? 2015-01-19T10:54:36.400

1 excel - how to count number of names in a column, name is specified in a cell 2015-03-23T05:51:43.370

1 Excel Sort and Lookup Values Formula 2015-09-10T05:29:48.863

1 COUNTIF and SUM in Excel with different ranges 2015-10-02T02:38:25.813

1 Count cells containing all 3 separate words in Excel 2015-12-10T02:29:36.820

1 Excel: conditional COUNTIF? 2016-01-11T14:04:21.503

1 How to use OR in a COUNTIF function when dealing with dates and ">" characters 2016-02-02T18:54:59.797

1 How does this SUMPRODUCT(COUNTIF( )) function work? 2016-02-02T22:13:58.667

1 Excel: Count the number of matches between lists 2016-03-16T15:33:27.057

1 How to use a an address formula as the limits of the COUNTIF range 2016-08-13T00:18:35.690

1 COUNTIF / Matching and determining repeating data 2016-08-15T14:52:48.360

1 Excel Query date range for Value 2017-01-26T16:46:53.190

1 Excel- add sequential numbers to column but skip if duplicate data in matching column 2017-07-11T13:28:54.740

1 CountIf Comparing Dates 2017-07-28T14:52:02.367

1 Excel countif not working as expected 2017-10-05T12:44:33.063

1 Excel count of number of times a unique value has been selected 2017-10-05T22:17:31.377

1 Counting Non-repeat-valued Cells in Excel 2018-01-30T07:48:36.713

1 how to save time with multiple COUNTIFS possibilities? 2018-05-13T17:36:25.397

1 Counting multiple ranged criteria 2018-05-27T09:14:37.387

1 COUNTIF Formula not returning expected values 2018-07-10T22:07:36.747

1 Count appearances of two-adjacent-cell value in range (Excel) 2018-09-29T14:11:11.323

1 Excel: Using COUNTIF but not including blanks with other formulas 2018-10-03T12:54:38.540

1 Count multiple letters in different cells 2018-10-29T01:19:23.913

1 How to use Excel to calculate concurrent streaks 2019-03-01T18:09:28.060

1 Cross table of joint games 2019-03-19T11:39:48.760

1 Sum the Count of Min of each column by row 2019-04-30T18:22:59.793

1 Count how many times string is contained within string within a range in excel 2019-06-03T15:49:45.947

1 Countif Date Array Formula 2019-10-19T05:30:55.467

1 Multiple values same line COUNTIF 2020-02-02T15:03:47.040

0 How can I run SUMIF or COUNTIF with two Conditions? 2012-10-02T18:48:33.207

0 CountIf Formula that counts cells containing any and all dates without having a date range? 2013-04-23T02:28:07.270

0 using functions in COUNTIF criteria 2013-12-06T10:05:05.907

0 Count instances of a letter in a row if a certain cell in that row contains a specified date 2014-02-21T03:39:22.133

0 Excel countifs criteria neither this nor that 2014-03-04T18:33:34.640

0 Count the number of times a value/string is in a column when other columns are filtered 2014-04-13T03:14:57.527

0 In Excel, checking if a cell matches one item from a named constant string list 2014-04-24T20:02:35.963

0 Excel COUNTIF Slow 2014-05-01T14:25:16.607

0 Why doesn't formula work on COPIED data? 2014-06-30T17:17:29.743

0 Countif incorrectly matches long number 2014-07-16T10:30:18.320

0 LibreOffice calc countifs with date 2014-08-12T20:10:13.477

0 Excel 2010 Formula: Finding a dynamic column based on string value, then count # of "0's" within that column 2014-08-27T13:17:24.437

0 How to count only shown in filter heading using COUNTIF (Excel 2010) 2014-09-09T11:19:35.677

0 Excel 2013 Multiple Validation Rules 2014-09-16T16:01:19.410

0 How can I set up logic to count the number of occurences in a month for a list of dates? 2014-09-17T15:57:32.337

0 Excel formula to count when value changes? 2014-10-31T21:05:53.707

0 Excel Countif Function Error 2015-02-05T20:10:35.920

0 Excel 2013 - Multiple Countifs 2015-05-05T01:35:46.663

0 Functions (specifically text functions) within a countif function 2015-05-19T16:38:36.967

0 Count two different text items in a row or column 2015-06-06T15:19:28.613

0 COUNTIF/COUNT Function help required to count the filtered data for the subsequent columns 2015-06-19T06:18:46.887

0 How to compare and sumproduct two cells value and use multiple criteria in IF in Excel 2013 2015-07-14T14:51:31.017

0 Count matches between two arrays 2015-09-03T16:17:31.513

0 How to count cells with values in another sheet's last column? 2015-09-05T09:15:09.560

0 Need unique count of text from multiple columns by category 2015-10-02T01:18:00.453

0 Excel counting "A"'s with cell values of "A,B" "R,A" etc 2015-10-30T12:32:51.737

0 Excel - For each unique ID, every time a particular column turns one, it needs to be cumulatively added 2015-11-24T01:06:03.487

0 Nested countif's frying my brain 2016-02-11T15:29:37.753

0 How to countif date in a specific column 2016-02-23T06:52:48.950

0 Countifs function: two criteria in the same range for text 2016-04-10T18:35:43.760

0 index and match 2 criteria with COUNTIF 2016-05-13T20:17:54.553

0 Count the amount of times a value appears combined with a certain event 2016-05-14T23:19:42.223

0 Countif or sumif formula 2017-01-04T08:57:30.750

0 How to Count the Items that Occur a Certain Number of Times in a List 2017-01-04T09:20:02.540

0 Dynamic dropdown in Excel 2017-01-23T15:38:24.507

0 count unique values that start with specific criteria 2017-01-24T17:00:16.750

0 Count number of instances in Excel based on another cell 2017-01-27T03:28:56.727

0 How do I assign values to cells? 2017-02-21T14:16:33.103

0 Excel: defining COUNTIF range based on values in a third column 2017-04-22T18:39:59.983

0 Counting the Number of times a text appears in column based on condition of two or more columns 2017-06-06T12:03:01.470

0 Countif with one Criteria, but only count Cost Center once 2017-07-10T12:10:13.720

0 Excel 2010 Conditional Formatting Accross multiple tables 2017-08-08T19:51:41.383

0 Crate dynamic sub-tables using IF, COUNTIF, INDEX, SMALL 2017-10-02T15:45:19.163