countif 4 conditions

Hi All, I'm not sure if this needs a Countif formula, a Sumproduct formula or something else. I have the following sheet and I'm tying to do a count based on multiple criteria I need to count based on the following Criteria in the Sheet "Trg Register" COUNTING CRITERIA In sheet "Trg...

I have a spreadsheet with more than 200 columns, and each column has different values with different sizes. I'm trying to find some sets of values and here are my questions; 1) How can I find the most frequently used set with size 3? (eg. CD8, CD3, CD4 or CD8, FoxP3, PanCK) 2) After I...

Hi All, I've tried countif using substitute, but I know I'm missing something. I can't figure out how to incorporate counting column B (numbers) if SOME of the text from column A matches column C, provide the total numbers of column B. Ultimately, I would need 8 different text to find. I'm...

Hello guys, I am facing a problem for which I couldn't find anything on this forum so far. I am trying to find how many agents with a certain skill are available during a 30 minute time frame based on their schedule(Table1). An agent can have multiple skills and those should be reflected in...

Hey guys! I am new to MrExcel and I have a confusing question for you all. I am working on an attendance tracker for work and we have a unique policy that for every 4 occurrences someone is late less then 25 minutes (tardy) they are given .5 a point towards their record I use "T" to identify...

Hello. I am trying to get a count of the cells that contain certain texts in one column (K) AND have a cell value greater than 2.5% (.025) in a different column (O) This is the formula I am using now: =SUM(AND(COUNTIFS(K:K,{"GROWTH1","GROWTH2","GROWTH3","GROWTH4"}),O:O>0.025)) I am getting a...