Top "Countif" questions

COUNTIF is an Excel function which allows for the counting of values in a range where the values meet a criterion.

Putting a concatenate inside of a count if

Alright, I have two excel functions that work. I want to combine them into one. Here are the two that …

excel concatenation excel-formula countif
Excel MATCH + COUNTIF function: retrieving the nth value in an array

I have a formula that I'm using in Excel to return the row # of the first item that matches a …

excel function countif excel-match
Have COUNTIFS ignore all blank cells (= empty cells and cells containing "")

I want to get a formula with COUNTIFS, like =COUNTIF(A1:A3,"<>"&"") such that when A1 = 2, A2 = "", …

excel excel-formula countif nonblank
Excel Countif Not equal to string length of zero

I have a formula an iferror formula that puts in "" if an error occurs. This is a zero length string. …

excel countif
Using a Variable in Excel for COUNTIF

First time question and I hope it's easier than I'm making this. Can I use a variable inside a COUNTIF …

excel variables spreadsheet formula countif
Excel array countif formula

I want to use COUNTIF function to evaluate how many items out of 2,0,0,5 are greater than 2? In Countif function, first …

arrays excel excel-formula countif
COUNTIF function if day of week is Tuesday

I need to count a column only if the corresponding cell in another column is a Tuesday. An example image …

excel excel-formula conditional-formatting countif array-formulas
Counting Colored Cells from a Conditional Formatting statement

So I'm revisiting this from yesterday: Multi-column vlookup conditional formatting Everything is working as intended with the conditional formatting statement …

vba excel conditional-formatting countif
How to use COUNTIF and COUNTA together in Excel?

I have a single column and I want to count how many rows do NOT contain "www." but at the …

excel excel-formula countif
Count number of occurrences based on 2 conditions or Regexp

How can I get the number of occurrences for some range based on A regular expression 2+ conditions; let's say cells …

regex google-sheets countif