Question about Microsoft Excel for PC

# Using count if command

I have a problem in excel using countif command, i want to count all the cells that are not paying a then subtract how many are not paying , how do i do that?

Posted by on

• Amit Bhasin May 11, 2010

Hi just want a bit of clarification. U want to count the number of of people who are not paying and then subtract the total amount is that what you want to do.

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that got 5 achievements.

Scholar:

An expert who has written 20 answers of more than 400 characters.

Hot-Shot:

An expert who has answered 20 questions.

• Expert

Is your problem solved or still need assistance.

Posted on Apr 18, 2008

• Level 1:

An expert who has achieved level 1.

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Mentor:

An expert who has written 3 tips or uploaded 2 video tips.

• Contributor

Posted on Mar 17, 2008

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### Countifs formula

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.

Nov 20, 2013 | Microsoft Excel 2010

### Count number of Delivery Status

To count textual values, use the countif function; the syntax is =countif(range,criteria). So, if your range, for example is B3 through B100 and you want to know how many cells contain the status value Delivered, put the following in the cell you want the count to show: =countif(b3:b100, "Delivered"). Do the same thing for each of your other status values in the cell that you want the count to appear.

Note that this requires each status value to be spelled correctly in each cell. I'd recommend assigning shorter values, say 1 through 5 or A through E to avoid that -- unless the values are being generated automatically so the spelling is guaranteed correct.

Jun 18, 2009 | Microsoft Excel for PC

### Hi, how do I find the 1st 2 letters in a cell and reference it to another. ie A1: 0209JJP001. I thus want to find "02" which is Feb (this would be a vlookup I assume). Therefore the 1st 2 letters...

To reference the first letters in a cell, use the left function. The syntax is =left(cell,#). So, to return the left two letters from cell A1, you use =left(a1,2). You can put that in a cell or incorporate it into some functions.

Jun 12, 2009 | Microsoft Excel for PC

### 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

### Countifs

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)

Jan 21, 2009 | Microsoft Office Excel 2003 for PC

### Using * in a EXCEL functions

=COUNTIF(M2,"*Fox*")

version of formula that will work
=IF(COUNTIF(M2,"*FOX*"),"yes","no")

Jan 08, 2009 | Microsoft Excel for PC

### EXCEL FORMULA 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.

May 27, 2008 | Microsoft Excel for PC

### 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

### Excel problem

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.

Dec 05, 2007 | Computers & Internet

### Multiple letters in each cell, want to add the letters and tally how many of each

Use the =COUNTIF function

For example if column a has the letters in it:

=COUNTIF(a1:a100,"a")
or
@COUNTIF(a1..a100,"a")

This will count all of the letter 'a' s in
column a from row 1 to row 100.

Mike

Oct 31, 2007 | Microsoft Excel for PC

## Open Questions:

#### Related Topics:

52 people viewed this question

Level 3 Expert

Level 3 Expert