Question on Conditional COUNTIF

[Guest]

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,

(e-mail address removed)

 

[Tom Ogilvy]

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
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Guest]

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))