Oh! Yeah the cell was just formatted wrong! Well, that worked to make the
formula give a value instead of ####.
But...the value is 0 which isn't correct.
Currently, I for the formula I have:

=SUMPRODUCT((TEXT($E$7:$E$100,"MMM")=ExecSum!H7)*( $F$7:$F$100="*New*"))

ExecSum!H7 contains the plain text value of FEB
There is one cell in E7:E100 that contains both a Feb date (1-Feb-06 to be
exact, and that is the product of a formula pointing to another document) AND
"New" within the value of it's cell in column F (not just 'New' though as
there's other stuff in that cell also, hence the asterisks). So, the value
should be 1, but it's 0.

So glad to know about the $. That would've saved me a lot of work. oh well
- now i know - thanks!
Ross

"cvolkert" wrote:


I'm not sure why the first formula won't work on your end. I tried it
again and it worked on my end (I did have to delete the space between
the 2 & the 0 in the latter part of the formula. You definitely don't
want to convert to the month number (using the Month function) or you
will get January for anything you put in there. One thing you may want
to try is format the cell where the formula is as a number - if it is a
date or something else that may be causing the #### which typically
means the cell contents are too large for the cell.

As for the $ - they make a range absolute. For instance, if you key a
formula in without $ and then drag it down or to the side, the cell
references in the formula will move relative to where the formula is.
this is usually not something people want to have happen.


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=514643