Question about Computers & Internet

1 Answer

Countifs solution for excel 2000

=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

Posted by ew44 on


1 Answer


  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer


Posted on May 08, 2009


Add Your Answer

Uploading: 0%


Complete. Click "Add" to insert your video. Add



Related Questions:

1 Answer

Countifs formula

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

1 Answer

Sum of the greatest run of negitive numbers

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 ;)

Oct 21, 2009 | Microsoft Excel for PC

1 Answer

I need a macro to use in excel 2000 which simulates the countifs function completely

You need to write a 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

1 Answer

Excel formula

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

1 Answer


The formula in both versions is the same:


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

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Using * in a EXCEL functions

Correction to your code

version of formula that will work

Jan 08, 2009 | Microsoft Excel for PC

3 Answers


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

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

Hope this helps.

May 27, 2008 | Microsoft Excel for PC

3 Answers

Excel Formula

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.

Apr 22, 2008 | Microsoft Excel for PC

1 Answer

Excel problem

Have you tried countif?

= countif(c:c, "Yes")


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

1 Answer


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

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

182 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts


Level 3 Expert

13434 Answers


Level 3 Expert

85239 Answers

Brad Brown

Level 3 Expert

18378 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides