conditional counting

[Guest]

I have a spreadsheet with the following data
A B C
Date Activated Jan Sales Feb Sales Mar Sale
1 01/25/04
2 01/26/04 $50.0
3 02/02/04 $62.0
4 02/12/04 $68.0
5 02/25/0
6 03/01/0
7 03/10/04 $20.0
8 03/15/0

i want to count
-number of "activations" in each month (i.e. number of activations between 1/1/04 - 1/31/04, 2/1/04 - 2/28/04, etc.
-number of activations in a a given month that had sale
-number of activations in a a given month that had no sale

 

[Frank Kabel]

Hi
try the following:
1. number of "activations" in each month:
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2004))

2. number of activations in a a given month that had sales (for
January)
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2004),--(B1:B100>0))

3. number of activations in a a given month that had no sales (for
January)
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2004),--(B1:B100=""))

--
Regards
Frank Kabel
Frankfurt, Germany

I have a spreadsheet with the following data:
A B C C
Date Activated Jan Sales Feb Sales Mar Sales
1 01/25/04
2 01/26/04 $50.00
3 02/02/04 $62.00
4 02/12/04 $68.00
5 02/25/04
6 03/01/04
7 03/10/04 $20.00
8 03/15/04

i want to count:
-number of "activations" in each month (i.e. number of activations

between 1/1/04 - 1/31/04, 2/1/04 - 2/28/04, etc.)

 

[Guest]

frank, your the man. thanks.

g