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
|