# Microsoft Excel for PC "countif" Questions

Question about Microsoft Excel Computers & Internet

## Excel Formula

...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. Just to point out, if you are ...

Question about Microsoft Excel Computers & Internet

## Excel formula

...many "x" values are in column AG from tab 1 and L from tab 2. What is the correct formula? Use the COUNTIF command. The COUNTIF command can count the criteria for a range of cells. Since you can

Question about Microsoft Excel Computers & Internet

## Using * in a EXCEL functions

...For example in cell M2 there is the wording Quick Brown Fox Jumps Over The Lazy Dogs Using COUNTIF(M2,="*FOX*"") produces a count of 1 Using IF(M2="*FOX*","YES","NO") produces NO as the ...

Question about Microsoft Excel Computers & Internet

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

...letter at the end of the spreadsheet to find the total number of a's, c's,e's, etc. Use the =COUNTIF function For example if column a has the letters in it: =COUNTIF(a1:a100,"a") or

Question about Microsoft Excel Computers & Internet

## Cannot get COUNTIF to work!

Cannot get COUNTIF to work! Here is my situation: I want to prevent duplicate entries of a loan number by the user. c has my loan numbers, and I want to prevent users from entering a loan number that ...

Question about Microsoft Excel Computers & Internet

## Sum of the greatest run of negitive numbers

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

Question about Microsoft Excel Computers & Internet

## Hi, how do I find the 1st 2 letters in a cell and

...count of cells in a range that meet a certain criteria? If that is correct, you want to use the COUNTIF function, which will count values in a specified range based on a specified criteria. The ...

Question about Microsoft Excel Computers & Internet

## EXCEL FORMULA PC

...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. The solution I've used in similar ...

Question about Microsoft Excel Computers & Internet

## Count number of Delivery Status

...Delivery Status Pending Delivery Pending PO Pending Quotation To count textual values, use the countif function; the syntax is =countif(range,criteria). So, if your range, for example is B3 ...

#### Popular Tags:

670 questions posted

Level 3 Expert

Level 3 Expert