Use SUMPRODUCT, wildcards can be avoided:

=SUMPRODUCT((MONTH(G7:G100)=9)*(F7:F100))

So if F7 thru G11 contains:

1 9/1/2008
2 10/1/2008
3 9/15/2008
4 6/6/2008
5 5/5/2008

the formula returns 4
--
Gary''s Student - gsnu200817


"MildJoe" wrote:

I want to pick out all the dates in september 2008 from a column of many
dates, and use it in a SUMIF, but an asterix or questionmark wont work like
this:
=SUMIF(G7:G8;"??.09.2008";F7:F8)
=SUMIF(G7:G8;"*.09.2008";F7:F8)