counitif

Hi All. Does one here know if it is possible to count the number of cells in a range that have a specific color? I have tried this and it does not work: ?Application.worksheetfunction.countif(Range("A1:A10);interior.color = rgbred))

I have a spread sheet that lists the date and time of an event in the separate cell (mm/dd/yy h:mm). I need to find a way to count the simultaneous calls. Then it will output the maximum number of simultaneous calls based from given data regardless of number of row . So for this example I...

Hello, Please help me build the count if formula based on criteria below: 1. I need to put a alert if any deal is over 2 days from contract date for TX state only 2. I need to put a alert if any deal is over 14 days from contract date for all other states...

Good day, wonder if anyone can assist me with some countif problems. I have a spreadsheet that i need to count how many instances of a number example Column A (other info in these columns not needed) Column H Tyres...

Dear Madame /Sir I am using an excel sheet where I am applying auto filters using VBA. In Column 6 , I have type of training (eLearning, InClass, Webex) and in column 7, I have time required for the training. After applying filter I am able to see how many hours of training required for...

I need help getting a formula to count how many instances happen between a certain time on a certain day. For example in column A5:A15 I have the Date of the incident and in column B5:B15 I have the Time of the incident. I want to count how many incidents happened between a certain time on...

I have a tab on a worksheet, call it tab B. It has a date issued, a goal close date, and an actual close date. I have another tab, call it tab A. That has the months listed in a row. I need to be able to count each time a date is past goal and put that under the month it was missed in tab A. I...

I have a workbook with species data, such as: **** sapiens, and the sites where data were taken (13). There are multiple rows of species just as there multiple columns of sites. How can I write a function to properly list the number of species at each site, by name? If there is no way to do...

Hi, I need formula for Countif with OR B2 = Count if A1= Xs1 or Count if A2= 9.5 My result should be 1 if A1/A2 = "" or any other critiria there. But if any of or both of the cells meets the critiria still answer will be 1