count

Hi, I have an issue that I've been struggling with and I hope someone could please help me out. At work we have a standby rota, with one sheet per month. In each sheet there's a rota, and essentially it looks like this (but with each date of the month in it); Fri Sat Sun Mon tue Wed...

I have a Microsoft Worksheet that I would like to create three cells with answers to the following questions for the range A1:AA41. 1. What function do I use to count the number of cells in this range? 2. What function do I use to count the number of cells in this range with a formula? 3...

Hi, I have a schedule of employees, that works in shifts. But i want to count how many people are working between 07:00 and 12:00 and between 12:00 and 16:00 and between 16:00 and 20:00 How can i do that, the begin time is in a cell and the end time is in the cell next to it. see down...

Hi guys i count B:B but in this column available sum data, i want skip this data and not count this cells, just count numbers

Hi Excel knowledge gods! I can create basic macros but I am struggling with with this one! What I am trying to do is create a macro to copy and paste two sets of characters, in A1 is the the first number (number of shelves), this can be any number from 1 to 20 (possible more), and the second...

Hi, I'm trying to count how many weeks a specific Product has been active. The Product has been active if they have a value for that week. The value in Column B has to match a defined value (i.e. A, B, C, D - the data in cells B12-B15), and then the data from columns C to G have to be...

Hi All, Please see below. I need a formula (in yellow cells) that will return how many times the number is counted as well as the corresponding row returning a "yes". So for example, cell BA3 should be 6. Bit stuck with this one so any help will be appreciated. Thanks in advance, Mark

Dear All, I am looking for a simple formula, which will display the number of days in a year. Kindly help me. Name DOJ EOS 2013 2014 2015 Employee 1 01-01-13 08-08-15 364 364 220 Employee 2 05-04-14 31-05-16 270 364 Employee 3 15-02-14 16-04-15 319 106

Hello. I have 3 different types of data in Range("A:A") : warnings, errors, good data. The criteria that makes a value either warning, error or good is stored in cells C1, C2, C3, C4. If the value of a cell in A:A is between C1 and C2 or between C2 and C3 it is a warning. If it is greater than...

Hello all, I have been struggling with this one and couldnt find answers on google! Though am sure the answer is fairly easy. So i have a list of duplicate values in a column as below. A A A B B C I need an excel formula (non vba) which results "3". Because we have only A, B and C regardless...

Hey friends. Im New in VBA. Could you help me at this? So, we have 2 columns: AB with data, in Sheet1 I want to COPY until Last Row in AB Column from Sheet1 and paste it to Sheet2, column CD in FIRST EMPTY ROW (i mean while adding more data, cause CD is supposed to have previous data) Can...

10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated. See attached spreadsheet.... I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green) In row 71 and 72 (in yellow), I would like to...

Hello, I really hope you are can help. Not going to lie been trying to figure this one out for the best part of 2 hours and have now given up. I have logged on for a while so I have breached any rules please let me know. So here goes. column B I have criterias that all have different...

How might I go about determining the following excel report Serial Low Moderate important Critical 11112 1 1 10616 1 1 10859 1 from this sheet? Thanks Host Serial Date Ship New Text abc 11112 1/1/2020 1/2/2020 11/6/2020 Moderate abc 11112 1/2/2020...

I have a large (100k rows) dataset with a set of about 10 columns. I need a formula to search those columns for a given value (which will then be something that gets repeated about 200 times for different values) and return the number of rows on which it finds that value in any of the 10...

To illustrate the formulas I need I've attached an example of what they should return. Dates are entered into column A. Then the cells get colored grey once they are processed. B2 is supposed to show how many cells are in column A that have a date in them but are not colored. C2 is supposed to...

https://www.mrexcel.com/board/threads/find-the-1st-2nd-3rd-common-text-w-criteria.1146002/ https://www.mrexcel.com/board/threads/top-10-most-common-text.1145758/ I don't think this is possible with just formulas but let's say I have 10 cells, and I want to find the top 5 most common words...

I have a list of passages in one column and a list of words or phrases in another column. Then I have a third column reserved for how many times each word or phrase appears in the column with the list of passages. For example: In column A (List of passages), A1: The red fox jumped over the red...

Hello. I am trying to count non-empty cells on another closed document with SUMPRODUCT. I am using this formula: =(SUMPRODUCT(('https://link/[Workbook.name]Worksheetname'!$Q$9:$Q$99999>"")+0)) Everything seems fine until the array encounters merged cells and returns #REF! from those cells as...