Nov 22, 2017 · Is it possible to create a formula to calculate how many cells contain specific text that has been selected from a list? eg Cell A2 can be user selected to be either 'Not Actioned', 'In Progress' …

Aug 12, 2021 · Find a cell that contains certain criteria, and count the cells in a row that do not contain specific text.

Jul 14, 2008 · Hello, can anyone please let me know if it is possible to create a pivot table but specifying a count where data within a column contains a specific string (similar to the option available when …

Oct 29, 2002 · Hi all, I need to count all the text entries in a range B4:B36 and when I use =COUNTIF(B4:B36,"*") it also counts the cells with formulas in them. Is there a way I can count the …

The Mar-18 column is actually coming from another cell with a meeting date in;four meetings in a month and I just want to group them into months, hence the MM-YYYY format.

Feb 13, 2012 · I need to use Countifs to count cells that contain text in another cell using cell reference instead of "*XXXX*". Plus another easy criteria. Similar to...

Jul 22, 2013 · That could be done with VBA, but an easier solution would be to add a field to your pivot field data source that evaluates to 1 if the description field contains "fixed" and 0 if it doesn't. If …

Nov 11, 2004 · Cell Contains Comma Delimited Items. For Each Delimited Item, XLookup (?) and Concatenate the Results Formula Only (No VBA) (LAMBDA??)

Dec 7, 2011 · Hi all, I want to count cells that contain specific text but multiple criteria. For example in range B4:B12 I want to count the cells that contain the word 'daily' AND the word 'weekly'. Each cell …

Jun 30, 2009 · I'm guessing you mean you want to count how many things in a list aren't striked through? There isn't a way to count based on formatting, but if you can put an x in a separate column …