Assuming that the dates in Column A are real XL Dates not text try:

=SUMPRODUCT((A2:A310<"")*(MONTH(A2:A310)=1)*(C2:C 310))

Adjusted to suit your own ranges.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"MikeJ" wrote in message
...
Hi
I have a large database like below. I need to pull data based on catagory,
subject and date. Example would be looking for catagory1, subject2 data
for
jan and get 29 or subject1 data for feb and get 7.I set up as database and
pull info for year using this formula =DSUM(Database,C$79,$B$99:$D$100)
but
can not get month to work

Date Subject1 subject2 subject3
1-Jan 10 15 20
2-Jan 6 14 3
""
""
1-Feb 7 5 3

Thanks
Mike