Count the number of specific values in a cell

Kevin

Posts: n/a

Count the number of specific values in a cell

I am using one cell to enter a list of dates. i.e.
3/9 3/11 4/27 4/28 5/4 5/5 5/9

I would like to count the number of times 3/ or 4/ ... occurs in this cell.

I read Bob Phillips post about using
=SUMPRODUCT(--(MONTH(A1:A20)=2)
or
=SUMPRODUCT(--(TEXT(A1:A20,"mmm")="Feb"))
but I am not sure how to use this. the "mmm" especially confuses me.

Thanks,

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
Trying to count specific values	JanetP3810	Excel Worksheet Functions	1	April 27th 05 11:46 PM
how do I make a word typed in a cell go to a specific cell in anot	Lmatarazzo	Excel Discussion (Misc queries)	3	April 21st 05 04:29 AM
How do you count number of characters in a single cell	Joe	Excel Worksheet Functions	1	February 18th 05 09:08 PM
How do you count number of characthers in a single cell?	Joe	Excel Worksheet Functions	2	February 18th 05 08:06 PM
spread the number 123.45 so each digit goes to a different cell	Linda H.	Excel Worksheet Functions	6	February 17th 05 07:07 PM

All times are GMT +1. The time now is 08:12 PM.

Menu

About Us