Need to use countif but I have 2 condition

  • Thread starter compare list A and list AB
  • Start date
C

compare list A and list AB

Dear All
I need to do countif but I have 2 condition to count for exp.
i have one column A the date for and i have on colume B the value i need to
look for
on specific cell i need to count number of value on Colume B with the
specific date that on column A.
again A is the date B is the value on the cell i need to count how may cell
has the value (24) on particular month.
Any one can help
Thanks
 
M

mzehr

Hi,
Try:
=SUMPRODUCT(--(YEAR(A1:A10)=2004),--(MONTH(A1:A10)=1)*(B1:B10=24))
will tell you how many cells have the value of 24 in the month of January in
2004
 
C

compare list A and list AB

NO let put it in this way I need to count who many cell in colume A has a
value "N" but only for the corresponding colume B that has cell Value
"1/1/2004"
any one can help
 
D

Don Guillett

where a1 contains the date desired
=sumproduct((colarng="N")*(colbrng=a1))
 
C

compare list A and list AB

Thanks for help but give you better exp.
on Column C cell number C8 I need to find this
1- count how may value in column B has value "N" Just and only for the
corresponding value In Colume A that has the value "2/2003".
in other way i need to konw who many cell has value N for particular
corresponding colume.
Thanks
 
A

Angel160

I've just posted a very similar thread. If you have any luck, pleas
let me know how you did it!
 
Top