If you are following this thread, the first formula that I posted:

=IF(ISBLANK($A$25),"""",SUMPRODUCT(('File A'!$A$13:$B$22=A28)*(TEXT('File
A'!$B$13:$B$22,"mmm")=$A$25)))

was what worked, since the date values were actual dates.

HTH,
Bernie
MS Excel MVP


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Srikanth,

Sure - send away. Make the obvious changes to my email address.

HTH,
Bernie
MS Excel MVP


- Show quoted text -

Thanks again Bernie, I used both the formulas, but somehow my
resultant is #VALUE... Can i send you the file along with the formulas
i have used. Your assistance is appreciated.
Thanks Again!
Srikanth HN