Count totals with date

[John Crawford]

Hi

I need to count the total licences by type used weekly but display the
answer monthly.

I think it should be something like:

=SUMPRODUCT((MONTH($C$2:$C$12)=1)*(YEAR($C$2:$C$12)=2004)) will count
the number of date entrys, but I dont know how to put the rest of it
together.

Can any one help?

A B C
Licenses Totals Date
Web-mail 19392 01/03/2004
POP 19392 01/03/2004
Web-mail 99827 08/03/2004
POP 99827 08/03/2004
Web-mail 11023 15/03/2004
POP 11023 15/03/2004
Web-mail 10067 22/03/2004
POP 10067 22/03/2004
Web-mail 11109 29/03/2004
POP 11109 29/03/2004
Web-mail 11153 05/04/2004
POP 11153 05/04/2004

 

[Frank Kabel]

Try
=SUMPRODUCT((MONTH($C$2:$C$12)=1)*(YEAR($C$2:$C$12)=2004),$B$2:$B$12)

 

[John Crawford]

Frank thanks, but how do I show the totals by Licences type i.e.

Web-mail, monthly total
POP, monthly total

regards

jfc

 

[Frank Kabel]

Hi
either try formulas like
=SUMPRODUCT(($A$2:$A$12="Web-mail")*(MONTH($C$2:$C$12)=1)*(YEAR($C$2:$C
$12)=2004),$B$2:$B$12)

or consider using a pivot table for this. See
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
for more information about this

 

[John Crawford]

Frank

Again many thanks

JFC

Hi
either try formulas like
=SUMPRODUCT(($A$2:$A$12="Web-mail")*(MONTH($C$2:$C$12)=1)*(YEAR($C$2:$C
$12)=2004),$B$2:$B$12)

or consider using a pivot table for this. See
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
for more information about this