count cells with text

So I have a mess I'm trying to work with. What I'm trying to do is if column G or H has a date in it (isn't blank), count the cell as 1 and return the number. While I don't have an issue with that part, my complication comes in if there's a value (not blank) in column H- that is, it counts it...

Hello, I'm looking for a count formula that counts the total number of sheets per person excluding duplicates. For example, below Nate has FTM01 and SM02 sheets assigned to him. His name is shown as 3 times in the table but the sheet names are the same for two of the items below. The answer...

I am trying to build a nested formula that will search in a url string for a set of keywords and return a label. I have tried several different ways of doing this and have not been successful. Here are my attempts. Thanks in advance for any assistance on this question...

HI GUYS I AM NEW TO THIS FORUM I AM BALDY STUCK IN MAKING FORMULA IN EXCEL 2007. CAN ANY BODY TELL ME ? THIS IS THE SAMPLE DATA BELOW. I WANT TO COUNT THE " MEDIUM CELL VALUES" BASED ON " DISTRICT COLUMN VALUES" FOR EXAMPLE: IT WILL GAVE ME THE FINAL RESULT AS. DISTRICT--> JAMSHORO HAD...

I update several data sheets daily. One portion of the macro applies a filter, sets the copy range, applies the offsets, and pastes the values into the first empty position in Column B, between 300-400 rows of data, leaving Column A blank. I need to copy a date from another workbook and past...

Hi; I was hoping some one could assist me with formula. =COUNTIF($F$2:$F$1914,"A2C") Here is my formula, What I am trying to achieve is read the value from other cells =COUNTIF($F$2:$F$1914, B11) But when I update it the top formula... it will show 0. am i missing something ? or is...

I am working on two worksheet in the same workbook, wsSheet1 and wsSheet2, and I need to do an autofilter (unique = true) in wsSheet1, count the lines and insert one line for each value on wsSheet2, but I just can't get it done! So far my code is not filtering only cells with values, so I can...

Hi I have an array of boxes corresponding to each day of the month, into which I enter periods of sickness/absence by marking each day off with an "S". I can then count the number of days sick quite happily. I've been asked to count the number of occasions of sickness now, for example a person...

I have an excel file with the names of the professors, and the dates of their publications. I want to use the file analyze publications put forth my university's faculty. Here is what is in the original sheet with base data: column A: professors' names column B: date of publication <tbody>...

Hi There, I'm looking at writing a formula to count the number of days worked since an employees last day off (results to appear in E7) From how my spreadsheet is designed, I'm needing to count the number of start/finish cells in Row 7 (F7:G7,J7:K7, and so on) until I get to a blank...

I want to count the number of cells in column C with one forumla that answers the question, "How many of the cells in column C contain the words, APM, BPPM, CAPM, and NMS while exluding any results that have "OUTLOOK" in Column K?

Excel 2010 Sheet 1 contains range B12:B353 with names of people. Sheet 2 range B12:B353 contains a formula to extract the names from Sheet 1 if range D12:D353 contains a certain value: =IF(Sheet1!D12:D354="A",(Sheet1!B12:B353)," ") At the bottom of each column in Sheet 2 I am trying to get...

Hi, I am trying to count the number of cells matching a text (weekly, monthly, bi-monthly ect). The problem is that the range cannot be A1:A30, rather it is A10;A14;A18;A22.... How would I go about calculating the number of cells in the sheet where the actual sales in catman solution is weekly...