=COUNTIFS(List!$O$2:$O$328;"<>YES";List! $G$2:$G$328;"<>Y";List!$E$2:$E$328;"<>DONE";List!$E$2:$E$328;"<>FIN";List!$F$2:$F$328;"<>AOL";List!$F$2:$F$328;"<>NO";List!$F$2:$F$328;"<>ON";List!$T$2:$T$328;"<>YES") how do i do this in excel 2000? Thanks! Eddy W

Ad

=SUMPRODUCT(--(List!$O$2:$O$328<>"YES"),--(List!$G$2:$G$328<>"Y"),--(List!$E$2:$E$328<>"DONE"),--(List!$E$2:$E$328<>"FIN"),--(List!$F$2:$F$328<>"AOL"),--(List!$F$2:$F$328<>"NO"),--(List!$F$2:$F$328<>"ON"),--(List!$T$2:$T$328<>"YES"))

Posted on May 08, 2009

Ad

COUNTIF(range,criteria)

Counts the number of cells within a range that meet the given condition.

This COUNTIF formula appears to count only the Employees that have the value "F" in the designated container. ie. Female.

Counts the number of cells within a range that meet the given condition.

This COUNTIF formula appears to count only the Employees that have the value "F" in the designated container. ie. Female.

Nov 20, 2013 | Microsoft Excel 2010

Hi, Not sure if this is what you have tried:

1: Assuming each run is on a different column

Run1 Run2 Run3 Run4, etc...and the maxium lenght of each column is 9 values, but each colum has a different lenght of numbers..

Then you can use:

=MAX(COUNTIF(A2:A10,"<>0"),COUNTIF(B2:B10,"<>0"), {keep adding countif for each colum).

If all runs are on the same colum, then using Pivot tables is easier. If you have a copy of your data, please post it so that I can give you the exact formula ;)

1: Assuming each run is on a different column

Run1 Run2 Run3 Run4, etc...and the maxium lenght of each column is 9 values, but each colum has a different lenght of numbers..

Then you can use:

=MAX(COUNTIF(A2:A10,"<>0"),COUNTIF(B2:B10,"<>0"), {keep adding countif for each colum).

If all runs are on the same colum, then using Pivot tables is easier. If you have a copy of your data, please post it so that I can give you the exact formula ;)

Oct 21, 2009 | Microsoft Excel for PC

You need to write a for..next loop that loops through the range you would set in the COUNTIF function. In each iteration of that loop, do your comaprisin test. Declare a varialbe to hold the "count" so when the loop ends, you'll have a resulting value.

Apr 27, 2009 | Microsoft Office Excel 2003 for PC

Use the COUNTIF command. The COUNTIF command can count the criteria for a range of cells. Since you can only use it for one range of cells or criteria, you simply add another criteria to the formula as follows: =COUNTIF(AG1:AG5,"X")+COUNTIF(Sheet2!L1:L6,"X")

Apr 10, 2009 | Microsoft Excel for PC

The formula in both versions is the same:

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

=countif(A1:B9,1)

=countif(range,value)

i.e. The below formula will increase its count by one if any of the 18 cells it's checking are equal to 1.

=countif(A1:B9,1)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

Correction to your code

=COUNTIF(M2,"*Fox*")

version of formula that will work

=IF(COUNTIF(M2,"*FOX*"),"yes","no")

=COUNTIF(M2,"*Fox*")

version of formula that will work

=IF(COUNTIF(M2,"*FOX*"),"yes","no")

Jan 08, 2009 | Microsoft Excel for PC

The solution I've used in similar situations is to create a 3rd column C with the items in column A and column B concatenated.

C2 = A2 & B2

C3 = A3 & B3

C4 = A4 & B4

etc.

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

C2 = A2 & B2

C3 = A3 & B3

C4 = A4 & B4

etc.

Then use COUNTIF function: =COUNTIF(C:C,"FredRed Ball")

Hope this helps.

May 27, 2008 | Microsoft Excel for PC

Lets say your data (cars) is in range "D1:D21".

You need to know how many are Dodge and Ford in cell E1.

=COUNTIF(D1:D21,"Dodge") + COUNTIF(D1:D21,"Ford)

Hope this helps.

You need to know how many are Dodge and Ford in cell E1.

=COUNTIF(D1:D21,"Dodge") + COUNTIF(D1:D21,"Ford)

Hope this helps.

Apr 22, 2008 | Microsoft Excel for PC

Have you tried countif?

= countif(c:c, "Yes")

The "Yes" is CASE SENSITIVE!

You may also have to do a combo:

= count(b:b) - countif(c:c "<>'Yes'")

Wher the 'Yes' is in single quotes and the entire condition is in double quotes.

= countif(c:c, "Yes")

The "Yes" is CASE SENSITIVE!

You may also have to do a combo:

= count(b:b) - countif(c:c "<>'Yes'")

Wher the 'Yes' is in single quotes and the entire condition is in double quotes.

Dec 05, 2007 | Computers & Internet

See if this is possible using the COUNTIF formula in Excel.
Example:
My range is A1:A20. Lowest number being 1 and highest number being 20.
To see how many are less than 10 I'd use:
=COUNTIF(A1:A20,"<=10")
To see how many are less than 20 but greater than 10 is a little different. (And this might be the crazy way). I do this:
=SUM(COUNTIF(A1:A300,"<=20") - COUNTIF(A1:A300,"<=10"))
Try this and see if it works for you. It seemed to work fine for me.

Sep 23, 2007 | Microsoft Office Standard for PC

182 people viewed this question

Usually answered in minutes!

×