I uploaded the file to here if you would prefer to get it publicly:

http://www.sendspace.com/file/hcuf6x

--
"Actually, I *am* a rocket scientist." -- JB

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


"JBeaucaire" wrote:

This is doable, but it's a pretty complicated array formula and it's
different for each month. I've mocked up a sheet and laid it out, I just need
to sent it to you.

My email address is

jerry
at
devstudios
dot
com

Drop me a note and I'll send it to you to examine.

Jerry Beaucaire

--
"Actually, I *am* a rocket scientist." -- JB

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


"JBeaucaire" wrote:

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.