Count reports per month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dewayne - 16 Aug 2006 21:52 GMT

I have a spread sheet that lists my reports by "customer name" in column "A"
and the "date the report was completed" in column "B". The date is formatted
mm/dd/yy (08/16/06).
I need a formula that gives me the number of reports that were completed in
each month of the year. The formula should be in a separate cell for each
month.
Thanks in advance for any help.

Signature

Dewayne

Reply to this Message

Bob Phillips - 16 Aug 2006 22:36 GMT

=SUMPRODUCT(--(MONTH(B2:B200)=ROW(A1)))

and copy down another 11 rows.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> I have a spread sheet that lists my reports by "customer name" in column "A"
> and the "date the report was completed" in column "B". The date is formatted
[quoted text clipped - 3 lines]
> month.
> Thanks in advance for any help.

Reply to this Message

Dewayne - 16 Aug 2006 23:56 GMT

Perfect. Thank you very much Bob!
Regards,

Signature

Dewayne

> =SUMPRODUCT(--(MONTH(B2:B200)=ROW(A1)))
>
[quoted text clipped - 10 lines]
> > month.
> > Thanks in advance for any help.

Reply to this Message