Question on Conditional COUNTIF

Question on Conditonal Countif · Feb 13, 2005

Hi,

I have a huge data base in which the first column is a date. The following
comuns have non-numercial data that I need to count in a monthly basis.
For example, column B could be either "W", "S", or "B"; I need to know how
many "W", "S", and "B" are in January, February, and so forth.

I tried to use an embedded IF clause, but did not work.

Thanks for you help

Suzanne,

[email protected]

Tom Ogilvy · Feb 13, 2005

You can do this with a pivot table.

Data=>Pivot Table
After setting up the pivot table, select the date field and group on Month.

See Debra Dalgleish's site (Look under P )

http://www.contextures.com/tiptech.html

--
Regards,
Tom Ogilvy

"Question on Conditonal Countif" <Question on Conditonal
[email protected]> wrote in message
news:[email protected]...

Ola · Feb 13, 2005

I think this should work:

Month...W...S...B...
1.......=SUMPRODUCT(--(MONTH(A2:A100)=1)*(B2:B100="W"))
2
....
12

Ola Sandstrom

Note:
The formula above is "easy" to understand and the below is more Copy friendly
=SUMPRODUCT(--(MONTH($A$2:$A$100)=$L2)*($B$2:$B$100=M$1))