Posted to microsoft.public.excel.misc

Shoelaces

external usenet poster

Posts: 3

Count By Month

"Teethless mama" wrote:

=SUMPRODUCT(--(TEXT(A2:A100,"m")="5"))

If I am not mistaken, this returns how many records are in the month of May.
I am interested in how many records are in May 2005, how many are in May
2006, and how many are in May 2007 individually, not collectively.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count # of Saturdays in a month	Dave	Excel Discussion (Misc queries)	1	April 17th 07 04:43 AM
Count reports per month	Dewayne	Excel Worksheet Functions	2	August 16th 06 11:56 PM
Count the dates in a month	s2m via OfficeKB.com	Excel Discussion (Misc queries)	5	August 4th 06 05:38 PM
count by month	gpoky	Excel Worksheet Functions	2	March 7th 06 04:28 PM
PivotTable - Count by Month	Gigi	Excel Worksheet Functions	3	January 1st 05 12:30 PM

All times are GMT +1. The time now is 04:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us