counted

Hi, It may be the time of night, but i can't for the life of me figure out how to stop my formula from doubling some results. The formula i am using is =COUNTIF(W251:W273,"*O*")+COUNTIF(W251:W273,"*+*") The formula is to count how many overtime shifts are being worked that day. The cell will...

Hi, I wondered if you could help as I've had a look on here and couldn't find how to do this exactly I need you count how many part number are in a row based on a multiple criteria, as you can see below the multiple criteria below, as you can see in the example below 111256 & 365446 are...

I am looking for a formula that will allow me to count text less than 2 and exclude blank spacing. So if it is one letter it would be wrong and if its one letter with a space it will still be counted as wrong. 2 Characters is the min. Please help

Hello, I need to find out how many calls come in, for any given day in a month from 7a-7p,. Criteria is in hour increments 7a-8a, 8a-9a, 9a-10a, 10a-11a, 11a-12p, 12p-1p, 1p-2p, 2p-3p, 3p-4p, 4p-5p, 5p-6p, 6p-7p (12 possible groupings). Example: if I had calls from 07:01, 07:59, 08:00 and 08:59...

Hey Guru's!! I've done a counta =COUNTA(L4:M10000) which gives me every cell with data. but ....... I also need unique's in that if L4 and M4 both have data it's only counted once? I know it's going to be something simple that i'll smack my forehead in shame for after but you guys always...

In a service, below 3 months of service will not be counted. Three or more than three months of service will be counted as next 6 months qualifying service.How will i calculate it in excel? For example: 15 years 2 (<3) months to be calculated as 15 years. 15 years 3/4/6/7/8...

If B3 contains text and F3 is blank, I want F3 to be counted. Could I have a formula that enables this?

Hi All, I'm using the below formula to try and calculate count of dates that are older than 90 days old between two columns (AK and AM). I want to make sure that should the value in AK AND the value in AM both be older than 90 days, they are only counted once...

In Excel 2010 I have a range of cells that each contains a formula. This range of cells is counted using '=COUNT("Range")'. I would like to use VBA to exclude a cell from being counted, but also being able to change my mind and include it again. So I want to be able to toggle if a cell is...

How to find the average of all the positive numbers above 0 and bellow 0 from H4:H20, so the cells with 0 wont be counted?

I want to create a 'Totals' column (column C) that will count certain values twice. How do I express the following as a formula: C1 = (A1 x 2) + B1

Hi, I have column A with 2198 items (every item has a unique item number) and column K with letters A or B or C example: column A ....... column K 250310 A 250350 B 250110 B 310140...

Hello, Is there a function that allows you to skip holidays (not count) when working with date ranges? I don't want to use the WORKDAY.INTL or WEEKDAY, etc. I just want the holidays that I indicate not counted. No matter what day of the week they fall on within my range. Let me know if this...

Hi to everyone, How can I exclude two values (value zero and value one) from being counted? I will be too happy if you can help me.:confused::confused::confused:

Hello, suppose the following: I have a list of various departments. I want to count how many times each department shows up in a list. However, I am also only looking for it to be counted if another separate column doesn't have an 'x' in it. What formula could I use for that? Example below: A...

Hello, I am trying to write a COUNTIFS formula to include a criteria that will subtract a value in column P from the row below in column I and if the result is less than 0 then it should be counted, but I can't seem to write this correct so that excel will accept this. Any help is appreciated...

Hello Im using this formula below but I would like to skip empty cells in column K o that the empty cells are not counted, is there a way around this? Thank you in advance

I am trying to use a countifs with percent ranges Example count a range with numbers 95% through 99.99%. So 94.99% and below wouldnt be counted nor would anything 100% and above.

I have 2 columns. Names are NAT_APP and NAT_BAS_Evidence Both columns are GENERAL I want to count where NAT_APP is "B" and NAT_BAS_Evidence is 6 Formula =COUNTIFS(NAT_APP,"*B*",NAT_BAS_Evidence,"*6*") If Column NAT_BAS_Evidence has a '6 it is counted but a 6 is not counted. Why??? I do not...

I am looking to get a count of unique combinations from 3 cells. The order of the combination does not matter. So in below example the first two rows would be counted as the same combination. The other rows would be counted as different combos. 23 24 25 25 23 24 23 24 23 thanks!