Well, guessing a little here. Are you manually deciding on the 3-digits to
look for? From your dataset I chose 703. Since the cells with that data in it
also have dashes, I think excel believes that data to be text, so I put "703"
in the formula to treat it as text, too.

This is also a CSE formula (Ctrl-Shift-Enter), and result in 65 as the answer:

=SUMPRODUCT(--(MONTH($A$1:$A$4)=12),
--(LEFT($C$1:$C$4,3)="703"),$D$1:$D$4)

Is this closer?
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"PointerMan" wrote:

I have about 30 columns of data that start with a date in each of them. I
want to pull all of the January (February, etc) dates from each of the
columns into one column in another worksheet. My second column will have
titles January, February, March, etc and will be filled with the appropriate
data from the first sheet.