Try this:

=IF(AND(MONTH(A1)=MONTH(A2),ISNUMBER(A2)),"",SUMPR ODUCT(--(MONTH(A$1:A$9)=MONTH(A1)),B$1:B$9))

copied down

Biff
Microsoft Excel MVP

"tqm1" wrote in message
...

Now, Monthwise Total

How to get monthwise total in column C as below

----A--------B---C
08-03-2007--10--
11-03-2007--20--
11-03-2007--30--60
14-04-2007--40--
30-04-2007--50--
18-04-2007--60--150
18-05-2007--70--
18-05-2007--80--
21-05-2007--90--240




--
tqm1