CountIf 2 columns

[Phippsy]

Hi

I need a formula to count cells in one column containing dates depending on
the contents of a differnt column like SumIf has the option

 

[Eduardo]

hi
=COUNTIF(A2:A5,"South")

 

[Jacob Skaria]

If you are looking to count the dates which falls on a certain month..try the
below formula which count the number of dates in ColA which falls in the same
month as the date specified in cell B1.

=SUMPRODUCT(--(TEXT(A1:A100,"mmyyyy")=TEXT(B1,"mmyyyy")))

If this is not what you are looking for please elaborate with an example..

 

[Jacob Skaria]

You can add more conditions as below....

ColA date = same month as in cell B1 and ColC = cell D1

=SUMPRODUCT((TEXT(A1:A100,"mmyyyy")=TEXT(B1,"mmyyyy"))*
(C1:C100=D1))