View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Formula to COUNT certain criteria

Hi Davis,

assuming that your code is in column A and the submissions in column B
you can use SUMPRODUCT. For your example enter the following formula:
=SUMPRODUCT((A2:A999="NEW")*(B2:B999=100))

HTH
Frank

DAVIS wrote:
Hello,

We are hoping to set up a formula to effectively counting
weekly data (instead of manually counting them). We
usually have a set of raw data coming from a database and
wants to identify have many of them are =100, =50, <=10,
and etc... Base on the code (HGR, NEW).

Is there a way that I can look up a particular code (NEW)
first and see how many of data that are =100 within this
NEW code. In the example below, the count would be "2"
because 2 of them have =100 submissions.


Example:
Code Submissions
HGR 105
HGR 100
HGR 58
NEW 10
NEW 5
NEW 63
NEW 105
NEW 110

Thank you in advance!!!
Davis